Updating multiple fields and rows in a form

[jackiw]

I have a form with "x" rows fetched from a database and 3 fields, which are ID, Name, Value. The ID field is a hidden input and the user can update de name and value.

The problem is that I don't know how to update multiple rows at the same time and I was reading other threads but there's nothing explaining this situation. I'm stuck.

if($action == "edit") {
 foreach($_POST as $key => $val){ 
 ... (what goes here?)

 mysql_query("Update USERS set name='???', value='???' where id='???'");
 }

}

[PallaviDalvi]

heres the outline of what u have to do. in a hidden field u need to have the count of rows and post it...so lets assume ur $POST['total_rows'] has the no of rows.

for ($counter=0;$counter<$_POST['total_rows'] ;$counter++)
{
	// the update query...
	mysql_query("Update USERS set name='". $_POST['name_'. $counter] . "', value='" . $_POST['value_'. $counter] . "' where id='" . $_POST['id_'. $counter] . "'"); 
}

here i assume that each ID, Name, and Value textfield in the HTML form is named as id_0,name_0 and value_0 and so on. u can create any other easily usable name.
hopefully it solves ur prob.

[jackiw]

Thank you PallaviDalvi, that works.