Radio Buttons and mysql

[white10]

Hi Guys

I am loading a test from a database, which contain all the questions and possible answers, Now what i want to do is display the possible answers as radio buttons and check if the user selected the correct radio button.(i will use the variable $cat_letter to check the value of the radio button selected.)

I want to checked if each radio button selected is equal to $cat_letter and then add 1 to it if not add 0 and conitue with the while loop

Can any of you guys be of help to me...

<?php
  session_start();
    include "db_connect.php";
 
$get_cats = "select * from
    tests1";
	 
  $get_cats_res = mysql_query($get_cats) or die(mysql_error());
  
 if (mysql_num_rows($get_cats_res) < 1) {
   $display_block = "<P><em>Sorry, no categories to browse.</em></p>";
} else {
  
  $display_block .= "  <table  width='574' border='1' cellpadding='0' cellspacing='0' >
   <tr>
				 <td>
   <h2>$cat_title </h2>
    </td>
				 </tr>";
  $hold[];
  
while ($cats = mysql_fetch_array($get_cats_res)) {
       $cat_id = $cats[id];
	    $cat_description = stripslashes($cats[description]);
        $cat_letter = stripslashes($cats[letter]);
		$cat_answer_a = stripslashes($cats[answer_a]);
		$cat_answer_b = stripslashes($cats[answer_b]);
		$cat_answer_c = stripslashes($cats[answer_c]);
		
        $display_block .= "<tr>	 <td width ='30' class='style17'>$cat_id	 <td/>	 <td align='center' width ='294' bgcolor='white' class='style19'>$cat_description<td/> <td width ='80'>
					 $cat_answer_a
					  <INPUT TYPE='radio' NAME='one' VALUE='a' 'checked' >
					
					 $cat_answer_b
					  <INPUT TYPE= 'radio' NAME=\"one\" VALUE=\"b\" >
					 
					
					 $cat_answer_c 
					  <INPUT TYPE= 'radio' NAME=\"one\" VALUE=\"c\" >
					 
					 <td>
					 
					 </tr>";
					 	 
					 
					 
	   }



 $display_block .= "</table>";
}

?>

[bsboard]

What you are going to want to do is numerically name each radio button set, which coincides with the row from the database. Something like 'radioset1', 'radioset2', ...

You can then loop over the results while $_POST['radioset'.$i] is available (start $i at zero, and increment it inside the while loop). If that value matches the current cat_letter from the database, then increment your 'score' counter.

Let me know if you need more explanation, its late and I'm tired, so probably aren't explaining it well.

Actually, you can read up on it some here: http://php.codeislogic.com/database-...-radio-buttons

[white10]

Thanks bsboard,
that work quite well, thanks for the help.. I figured out another way to do it but the code was way to long, yours is much shorter...