help with multiple UPDATE query...

vaska

help...i have a looped output of checkboxes in a form, and when i press "submit" i want to have them UPDATE all the corresponding records WHERE id='$id'...i'm just not sure how to do this...

this is the UPDATE query...as it is...it's only holding one set of values...

// multiple updates...
if ($submit) {

$result = mysql_query ("UPDATE main SET id='$id', admin2='$admin2' WHERE id='$id'") or die ("Not working! [2a]"); 
header("Location: page.php");
}

this is what the form part looks like...i'm not pasting the code because the phpbuilder system keeps playing with the url and making it unreadable...it simply looks like this...

http://www.someurl.com/link.php?id=12 [checkbox-checked-value=1-name=admin2]
looped 15 times...

this is the query that provides the information FOR the outputs i use in the checkbox/form part...

// load first query...

$query = mysql_query ("SELECT html,id FROM main WHERE admin1='1' and admin2='0' ORDER BY id ASC LIMIT 0,15 " ) or die ("Not working! [1a]"); 
$row = mysql_fetch_array($query);

any help would be much appreciated...i hope i've provided enough info...jv

vaska

because i have so many times found the answers to my questions in these forums...i will post the solution to this problem...

the query ended up looking like this...

// multiple saves...

if ($submit) {

   for($i=0;$i<sizeof($idbox);$i++) {
   $query="UPDATE main SET admin2 = 1 WHERE id = $idbox[$i]";
   $result=mysql_query($query);

   }
   header("Location: main.php"); 
   }

the form/checkbox area looked like this...

<? do { ?>
    <input name="idbox[]" type="checkbox" value="<? echo  $row['id']; ?>" checked>
    [url]http://www.somesite.com/link.php?id=[/url]<? echo  $row['id']; ?><br>
    <? } while($row = mysql_fetch_array($query));?>

the key...was to have the id passed to the query...since the value of the field was going to remain constant this was just placed into the query...the value in the form area is not even used but should remain unique...so i just placed the "id" number in this area for the heck of it...

on submit...it runs the update the apprpriate number of times and voila...works very nicely...jv