UPDATE multiple rows

[empnorton]

I have a table where the last two columns are populated with true or false - and only two records should be true at any one time. Thus I have set up an interface where all the relevent records are displayed with radio buttons in the final two columns. The radio buttons are arrayed vertically, and within each column all have the same name="" value so that users can not do multiple selections.

I want to allow users to change select a new radio button, thus facilitating the need to UPDATE four records whos unique ids cannot be known beforehand.

Someone in the DB section suggested that I on post, I might set ALL the variables in those columns to false, and then set the two that I need back to true, but I am not sure how I might do that.

I am fairly new to php/mysql, so explicit examples that I can cut and paste would be appreciated.

Thanks in advance,

./empnorton

[empnorton]

Okay, I figured out part of this, and wrote the script below. However, whenever I submit, the script errors out.

Anyone spot what I have done wrong?

//radio buttons (these are generated in a loop)
<input name="spotlight_l" type="radio" value="' . $id . '" checked="checked"/>
//submit script

<?php
if($submit) {
foreach ($HTTP_POST_VARS as $name=>$value){
$i=1;

if ($name == "spotlight_l"){

$SQL = "UPDATE homepage SET spotlight_l='$i' WHERE hpid='$value'";
$result = mysql_query($sql) or die("db query failed_1");

} else {

if ($name == "spotlight_r"){

$SQL = "UPDATE homepage SET spotlight_r='$i' WHERE hpid='$value'";
$result = mysql_query($sql) or die("db query failed_2");}
}
}
}
?>

[planetsim]

to make it easier to read use the php tags.. that this forum uses....

And i think your error is 1 to many } at the end