i'm having problem with survey script and voting function. can anyone please help me out.. the script only accept the last question's answer and update the database = acount+1.
script to dislay survey:
<?php
echo "<form action='vote.php' method=post>
<table width='300' border='0' cellspacing='0' cellpadding='0' align='center'>";
$query1 = "SELECT * FROM questions";
$result1 = mysql_query($query1)or die("ERROR: $query.".mysql_error());
$num_row=mysql_num_rows($result1);
$i=1;
while($i<$num_row){
while ($row1 = mysql_fetch_array($result1)) {
$qid = $row1['qid'];
$qtitle = $row1['qtitle'];
$query2 = "SELECT * FROM answers WHERE qid='$qid'";
$result2 = mysql_query($query2) or die("ERROR: $query.".mysql_error());
echo "<tr>
<td width='300' align='left'><p>".$i.". ".$qtitle."</p></td>
</tr>";
while ($row2 = mysql_fetch_array($result2)) {
$aid = $row2['aid'];
$atitle = $row2['atitle'];
echo "<tr>
<td width='300' align='left'><input type = radio name =aid value = '".$aid."'><font>".$atitle."</font></input><br></p></td>
</tr>";
}
echo "<input type = hidden name = qid value = '".$qid."'>";
echo "<br />";
$i++;
}
}
echo "<td><br><br></td><tr>
<td width='300' align='center'><input type = submit name = submit value = 'Submit'></td>
</tr>
</table>
</form>";
}
}
// close connection
mysql_close();
?>
voting script:
<?php
if (isset($_COOKIE) && !empty($_COOKIE)) {
if ($_COOKIE['lastpoll'] && $_COOKIE['lastpoll'] == $_POST['qid']) {
echo '<script>alert("You have already voted. Thank You !!!");</script>';
echo '<script>location.replace("trysurvey.php");</script>';
exit();
}
}
// set cookie
setCookie('lastpoll', $_POST['qid'], time() + 2592000);
if (isset($_POST['submit'])) {
if (!isset($_POST['aid'])) {
echo '<script>alert("Please select one of the available choices.");</script>';
echo '<script>history.back(1);</script>';
}
else{
require_once('config.php');
$aid=$_POST['aid'];
$qid=$_POST['qid'];
// update vote counter
$query = "UPDATE answers SET acount = acount + 1 WHERE aid = '$aid' AND qid = '$qid'";
$result = mysql_query($query) or die("ERROR: $query. ".mysql_error());
}
// close connection
mysql_close();
// print success message
echo '<script>alert("Your have successfully voted.");</script>';
echo '<script>location.replace("trysurvey.php");</script>';
}
else {
echo '<script>alert("Unable to submit your Vote. Please try again !!!");</script>';
echo '<script>history.back(1);</script>';
}
?>
please help.....