PHP form with radiobuttons

snappy

Hi all

Say I have the following form

<?
include "db.php";

$sql = "SELECT * FROM table";
?>

<form action = "" method = "post">

<?
$result = mysql_query($sql);
while($rows=mysql_fetch_array($result)){
	echo $rows['a'] . rows['b'] . $rows['c'] . $rows['d'] . 
			"choice1 <input type = 'radio' name = 'choice' value = 'x'><br>
			 choice2 <input type = 'radio' name = 'choice' value = 'y'>"
			;}
?>

<input type = "submit" name = "submit" value = "Update">
</form>

The radio buttons work as a group together, by which I mean that if the one is selected, all the others is deselected.

How would I get the radio buttons to work in pairs, and how would I code the $_POST[] bit to use the information that is posted from the radiobuttons ?

devinemke

i suggest you use the primary key field (id) from your table as the array keys. something like this:

$result = mysql_query('SELECT * FROM table') or exit(mysql_error());
while ($row = mysql_fetch_assoc($result))
{
	echo $row['a'] . $row['b'] . $row['c'] . $row['d'] . '<br>
	choice1 <input type="radio" name="choice[' . $row['id'] . ']" value="x"><br>
	choice2 <input type="radio" name="choice[' . $row['id'] . ']" value="y"><br>';
}

then you will have an array called $_POST['choice'] with the id's as the keys and the user's choices as the values.

snappy

Now I've tried this

form.php

<?
$result = mysql_query('SELECT * FROM table') or exit(mysql_error()); 
while ($row = mysql_fetch_assoc($result)) 
{ 
    echo $row['a'] . $row['b'] . $row['c'] . $row['d'] . '<br> 
    choice1 <input type="radio" name="choice[ . $row['id'] . ]" value="x"><br> 
    choice2 <input type="radio" name="choice[ . $row['id'] . ]" value="y"><br>'; 
}
<input type = "submit" name = "submit" value = "Update">
?>

and save_choice.php

<?

$id = $_POST['siteid'];
$choice = $_POST['choice'];
$submit = $_POST['submit'];

if(!$submit == "Update"){
include "form.php";
}elseif($submit == "Update"){

switch($choice)        

{
case "1":
$val="1";                    

break;

case "2":
$val="2";                   

default:
$val="0";
}
echo $val;
include "form.php";
$sql_value = mysql_query("UPDATE table SET value = '$val' WHERE id = '$id' AND user_id = '2'")
}
?>

why doesn't it update my db ?

msk_1980

You wont be able to use $choice with the switch because its an array. so you should be looking at using an for or a foreach to get to each value in the array.

Hope that helps.

snappy

Any suggestions on how the code will look ?