multiple upates to a table...?

[vaska]

ok...i want this to be many records...

// multiple saves...

if ($submit) {
$result = mysql_query ("UPDATE main SET id='$id', admin2='$admin2' WHERE id='$id'") or die ("Problems 1!"); 
	  header("Location: main.php");
	  }

any my loop with the data...

weird...this board is messing with the code...hmmm...just pretend the below info is fine...it's the smaller issue...

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

<input type="submit" name="Submit" value="Submit">

now...i'm a little lost...do i need to loop the query? and...how might i do this? and how does "submiit" know which ones it's updating...???

thanks...jv

[planetsim]

Can you try explaining again. I have no idea what you are talking about. Its all mumbo jumbo.

[vaska]

sorry...it shows what my day was like...very chaotic...

i'm trying to update multiple records in a table...

the first thing you see is the query...i'm not sure how to write this for multiple updates...

the second garbled mess...the important thing there is that there is a checkbox with a value of 1 that needs to be inserted in the table where each id='$id'...

it's the query though...i've never done a multiple update, and i haven't found any concrete info about this...

thanks...jv