i'm a beginner and new to php. 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 display 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... thanks in advance

The name's of you're fields are the same so it only takes the last one
You could use you're int $i to make the names different.

In the seccond loop, where you output the radio button, you can use the question ID as name attribute, as in

PHP Code:

echo '<input type="radio" name="' . $qid . '" value="' . $aid . '">'; 


Then you would end up with an array where the question IDs are keys and the selected awnser are value, as in

PHP Code:

$_POST = array(
   'qid_1' => 'aid_1',
   'qid_2' => 'aid_2',
   'qid_3' => 'aid_3',
   ...
);