Actually, I'll just put it here(it's long):
<?
////Vote, started 28/7/05.////
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>---Vote---</title>
</head>
<body>
<h1><div align="center">---Vote---</div></h1>
<br>
<?
//Connect...
$dbcnx=mysql_connect("localhost","username","password");
mysql_select_db("your_db", $dbcnx);
//Get all variables neccesary
$Ans1=mysql_result(mysql_query("select Ans1 from Vote_Answers", $dbcnx),0);
$Ans2=mysql_result(mysql_query("select Ans2 from Vote_Answers", $dbcnx),0);
$Ans3=mysql_result(mysql_query("select Ans3 from Vote_Answers", $dbcnx),0);
$Ans4=mysql_result(mysql_query("select Ans4 from Vote_Answers", $dbcnx),0);
$Ans5=mysql_result(mysql_query("select Ans5 from Vote_Answers", $dbcnx),0);
$Question=mysql_result(mysql_query("select Question from Vote_Votes", $dbcnx),0);
$Ans1n=mysql_result(mysql_query("select Ans1 from Vote_Votes", $dbcnx),0);
$Ans2n=mysql_result(mysql_query("select Ans2 from Vote_Votes", $dbcnx),0);
$Ans3n=mysql_result(mysql_query("select Ans3 from Vote_Votes", $dbcnx),0);
$Ans4n=mysql_result(mysql_query("select Ans4 from Vote_Votes", $dbcnx),0);
$Ans5n=mysql_result(mysql_query("select Ans5 from Vote_Votes", $dbcnx),0);
$ip=$_SERVER['REMOTE_ADDR'];
$NOP_query=mysql_query("select NOP from Vote_NOP", $dbcnx) or die(mysql_error());
$NOP=mysql_result($NOP_query, 0);
//Check if you have voted before and process votes
if (isset($_GET[vote]))
{
$blah=1;
while($blah<=$NOP)
{
if (mysql_result(mysql_query("select IP from Vote_IP where ID='$blah'", $dbcnx),0)==$ip)
{
echo"<h3>You have already voted!!! Stop trying to vote again!!!</h3>";
exit();}
$blah++;
}
if ($_GET[vote]=='Ans1')
{
$ansnew=$Ans1n+1;
mysql_query("update Vote_Votes set Ans1='$ansnew'", $dbcnx);
}
elseif ($_GET[vote]=='Ans2')
{
$ansnew=$Ans2n+1;
mysql_query("update Vote_Votes set Ans2='$ansnew'", $dbcnx);
}
elseif ($_GET[vote]=='Ans3')
{
$ansnew=$Ans3n+1;
mysql_query("update Vote_Votes set Ans3='$ansnew'", $dbcnx);
}
elseif ($_GET[vote]=='Ans4')
{
$ansnew=$Ans4n+1;
mysql_query("update Vote_Votes set Ans4='$ansnew'", $dbcnx);
}
elseif ($_GET[vote]=='Ans5')
{
$ansnew=$Ans5n+1;
mysql_query("update Vote_Votes set Ans5='$ansnew'", $dbcnx);
}
mysql_query("insert into Vote_IP values('','$ip')", $dbcnx);
mysql_query("update Vote_NOP set NOP=NOP+1", $dbcnx);
echo"Thank you for voting!<br><br>Results:";
//Display results
?>
<table width="335" border="1" cellspacing="0" cellpadding="0">
<tr>
<td width="34"> </td>
<td width="295"><? echo "Question: ".$Question;?> </td>
</tr>
<tr>
<td> </td>
<td><? if ($NOP==0){
echo $Ans1." : 0 votes, 0%";}
else{echo $Ans1." : ".$Ans1n." votes, ".(($Ans1n/$NOP)*100)."%";}?> </td>
</tr>
<tr>
<td> </td>
<td><? if ($NOP==0){
echo $Ans2." : 0 votes, 0%";}
else{echo $Ans2." : ".$Ans2n." votes, ".(($Ans2n/$NOP)*100)."%";}?> </td>
</tr>
<tr>
<td> </td>
<td><? if ($NOP==0){
echo $Ans3." : 0 votes, 0%";}
else{echo $Ans3." : ".$Ans3n." votes, ".(($Ans3n/$NOP)*100)."%";}?> </td>
</tr>
<tr>
<td> </td>
<td><? if ($NOP==0){
echo $Ans4." : 0 votes, 0%";}
else{echo $Ans4." : ".$Ans4n." votes, ".(($Ans4n/$NOP)*100)."%";}?> </td>
</tr>
<tr>
<td> </td>
<td><? if ($NOP==0){
echo $Ans5." : 0 votes, 0%";}
else{
echo $Ans5." : ".$Ans5n." votes, ".(($Ans5n/$NOP)*100)."%";}?> </td>
</tr>
</table>
<?php
}
else{
//Check if you have voted or not
$ip=$_SERVER['REMOTE_ADDR'];
$blah=1;
while($blah<=$NOP)
{
if (mysql_result(mysql_query("select IP from Vote_IP where ID='$blah'", $dbcnx),0)==$ip)
{
echo"<h3>You have already voted.</h3>";
//Show results
?>
<table width="335" border="1" cellspacing="0" cellpadding="0">
<tr>
<td width="34"> </td>
<td width="295"><? echo "Question: ".$Question;?> </td>
</tr>
<tr>
<td> </td>
<td><? if ($NOP==0){
echo $Ans1." : 0 votes, 0%";}
else{echo $Ans1." : ".$Ans1n." votes, ".(($Ans1n/$NOP)*100)."%";}?> </td>
</tr>
<tr>
<td> </td>
<td><? if ($NOP==0){
echo $Ans2." : 0 votes, 0%";}
else{echo $Ans2." : ".$Ans2n." votes, ".(($Ans2n/$NOP)*100)."%";}?> </td>
</tr>
<tr>
<td> </td>
<td><? if ($NOP==0){
echo $Ans3." : 0 votes, 0%";}
else{echo $Ans3." : ".$Ans3n." votes, ".(($Ans3n/$NOP)*100)."%";}?> </td>
</tr>
<tr>
<td> </td>
<td><? if ($NOP==0){
echo $Ans4." : 0 votes, 0%";}
else{echo $Ans4." : ".$Ans4n." votes, ".(($Ans4n/$NOP)*100)."%";}?> </td>
</tr>
<tr>
<td> </td>
<td><? if ($NOP==0){
echo $Ans5." : 0 votes, 0%";}
else{
echo $Ans5." : ".$Ans5n." votes, ".(($Ans5n/$NOP)*100)."%";}?> </td>
</tr>
</table>
<?
exit();
}
$blah++;
}
//Vote...
?>
<form name="form1" method="get" action="vote.php">
<table width="337" border="1" cellspacing="0" cellpadding="0">
<tr>
<td width="34"> </td>
<td width="297"><? echo "Question: ".$Question ;?> </td>
</tr>
<tr>
<td><input name="vote" type="radio" value="Ans1"></td>
<td><? echo $Ans1;?> </td>
</tr>
<tr>
<td><input name="vote" type="radio" value="Ans2"></td>
<td><? echo $Ans2;?> </td>
</tr>
<tr>
<td><input name="vote" type="radio" value="Ans3"></td>
<td><? echo $Ans3;?> </td>
</tr>
<tr>
<td><input name="vote" type="radio" value="Ans4"></td>
<td><? echo $Ans4;?> </td>
</tr>
<tr>
<td><input name="vote" type="radio" value="Ans5"></td>
<td><? echo $Ans5;?> </td>
</tr>
<tr>
<td> </td>
<td><input name="submit_vote" type="submit" value="Vote!"> </td>
</tr>
</table>
</form>
<?
}
?>
</body>
</html>
The tables are:
1 (Vote_Answers):
+-------+------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+------+------+-----+---------+-------+
| Ans1 | text | YES | | NULL | |
| Ans2 | text | YES | | NULL | |
| Ans3 | text | YES | | NULL | |
| Ans4 | text | YES | | NULL | |
| Ans5 | text | YES | | NULL | |
+-------+------+------+-----+---------+-------+
2 (Vote_Votes):
+----------+---------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+---------+------+-----+---------+-------+
| Question | text | YES | | NULL | |
| Ans1 | int(11) | YES | | NULL | |
| Ans2 | int(11) | YES | | NULL | |
| Ans3 | int(11) | YES | | NULL | |
| Ans4 | int(11) | YES | | NULL | |
| Ans5 | int(11) | YES | | NULL | |
+----------+---------+------+-----+---------+-------+
3 (Vote_IP):
+-------+---------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+---------+------+-----+---------+----------------+
| ID | int(11) | | PRI | NULL | auto_increment |
| IP | text | YES | | NULL | |
+-------+---------+------+-----+---------+----------------+
4 (Vote_NOP):
+-------+---------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+---------+------+-----+---------+----------------+
| ID | int(11) | | PRI | NULL | auto_increment |
| NOP | int(11) | YES | | NULL | |
+-------+---------+------+-----+---------+----------------+