Radio Buttons and Arrays

rivka

I must be missing something obvious: basically, I want to pull several rows of results from a table, print out the title of each row, and next to the title have two radio buttons -- one will be checked if a certain result is 1, and the other will be checked if it's 0. And then I need to be able to submit the form back, and make any changes based on the radio button selections. Here's my code for the display of the page with the radio buttons:

		$query = mysql_query("SELECT * FROM pictures_answers WHERE pid = '$pid' ORDER BY date DESC");
		while($result = mysql_fetch_array($query))
		{
			echo "<tr><td>$result[uname]</td><td>$result[answer]</td><td><INPUT type=\"radio\" name=\"radio[]\" value=\"$result[aid]\"";
			if($result[correct] == "1")
				echo " checked";
			echo "></td><td><INPUT type=\"radio\" name=\"radio[]\" value=\"$result[aid]\"";
			if($result[correct] == "0")
				echo " checked";
			echo "></td><td>$result[date]</tr>";
		}

What's going wrong is that it's only checking the correct radio button for the last row -- the html shows that the other rows have the correct radio button "checked" but it's not displaying that it's checked. So I figure I must have something wrong with the name or something. Help? And then, how do I do the next step to make it look at each row and update the column labelled correct (what the radio button is showing as 1 or 0)? A foreach loop?

KevinMG

you need to use checkboxes for multiple results

echo "<input type=\"checkbox\" ... >";

radio input types only can have one checked for every field with the same "name".

hope that helps 🙂

xblue

the above would allow multiple selection for the records, but as well selecting both options within each record.

if this is not what you want, you might want to stay with radio buttons, but you have to name them differently. instead of radio[] you could e.g. use radio_$id or radio[$id] (if your records have a unique id) or something like


$query = mysql_query("SELECT * FROM pictures_answers WHERE pid = '$pid' ORDER BY date DESC");
        $counter=0;
        while($result = mysql_fetch_array($query))
        {
            echo "<tr><td>$result[uname]</td><td>$result[answer]</td><td><INPUT type=\"radio\" name=\"radio[$counter]\" value=\"$result[aid]\"";
            if($result[correct] == "1")
                echo " checked";
            echo "></td><td><INPUT type=\"radio\" name=\"radio[$counter]\" value=\"$result[aid]\"";
            if($result[correct] == "0")
                echo " checked";
            echo "></td><td>$result[date]</tr>";
            $counter++;
        }
        unset $counter;

rivka

Hmm. This is much closer to what I want, but I'm still running into a wee problem. The $aid is the unique id, so I don't need to use the $counter exactly like you answered. And the only value I want to pass along is 0 or 1 between the two radio buttons. So now I have something like this:

		$query = mysql_query("SELECT * FROM pictures_answers WHERE pid = '$pid' ORDER BY date DESC");
		while($result = mysql_fetch_array($query))
		{
			$counter = $result[aid];
			echo "<tr><td>$result[uname]</td><td>$result[answer]</td><td><INPUT type=\"radio\" name=\"radio[$counter]\" value=\"1\"";
			if($result[correct] == "1")
				echo " checked";
			echo "></td><td><INPUT type=\"radio\" name=\"radio[$counter]\" value=\"0\"";
			if($result[correct] == "0")
				echo " checked";
			echo "></td><td>$result[date]</tr>";

The problem is now that when I submit the form, I need to do the foreach and update loop -- and I need the $aid info to do that. Check this out:

		foreach($radio as $value)
		{
   			mysql_query("UPDATE pictures_answers SET correct = '$value' WHERE aid = '$aid'");
		}

Now, obviously, I need the $aid to update each row, but how do I get that? Is that possible to do that with radio buttons?

rpupkin77

I've done this before but my approach was different. Iused a function:

function clubcheck($val, $club) {
if ($val == $club){
echo "checked";
}
}
?>

That is called this way:

The first variable is the value that the radio button has, if it is equal to the value ($clubs) pulled from the DB than the function echos "checked".