עדיין שגיאות...
קובץ VOTE.PHP
PHP קוד:
<?
include "global/global.php";
$vote = $_POST['vote'];
$query = mysql_query("SELECT * FROM poll ORDER BY id DESC LIMIT 1");
$rr = mysql_fetch_array($query);
$id = $rr['id'];
$quetion = $rr['quetion'];
$vote1 = $rr['vote1'];
$vote2 = $rr['vote2'];
$vote3 = $rr['vote3'];
$vote4 = $rr['vote4'];
$avg = $rr['avg'];
$query1 = mysql_query("SELECT * FROM poll_address");
$rr1 = mysql_fetch_array($query1);
$ip = $rr1['ip'];
$pid = $rr1['pid'];
if($myip == $ip and $pid == $id){
echo "לא ניתן להצביע יותר מפעם אחת";
}else{
@mysql_query("UPDATE poll SET vote{$_POST['vote']} = vote{$_POST['vote']} + 1,avg = avg + 1 where id='$id'") or die (mysql_error());
@mysql_query("INSERT into poll_address(ip,pid) VALUES ('$myip','$id'") or die (mysql_error());
}
?>
קובץ poll.php
PHP קוד:
<?
$myip = GetHostByName($REMOTE_ADDR);
$query = mysql_query("SELECT * FROM poll ORDER BY id DESC LIMIT 1");
$rr = mysql_fetch_array($query);
$id = $rr['id'];
$quetion = $rr['quetion'];
$option1 = $rr['option1'];
$option2 = $rr['option2'];
$option3 = $rr['option3'];
$option4 = $rr['option4'];
$avg = $rr['avg'];
$query1 = mysql_query("SELECT * FROM poll_address");
$rr1 = mysql_fetch_array($query1);
$ip = $rr1['ip'];
$pid = $rr1['pid'];
if($myip == $ip and $pid == $id){
echo "שגיאה";
}else{
echo '
<table border="0" height="155" style="border:1px soild black;">
<tr>
<td style="vertical-align:top"><b><font face="Arial">'.$quetion.'<br />
<form action="vote.php" method="post">
<input type="radio" name="vote" value="1" /> '.$option1.'<br />
<input type="radio" name="vote" value="2" /> '.$option2.'<br />
<input type="radio" name="vote" value="3" /> '.$option3.'<br />
<input type="radio" name="vote" value="4" /> '.$option4.'<br />
<input type="submit" name="submit" value="הצבע!" />
</form>
סה"כ הצבעות:
'.$avg.'</font></b></td>
</tr>
</table>
';
}
?>
שגיאת syntax בקובץ vote.php בשאילתה.