Updating Multiple rows in mysql w php at once (newbie)

From: Date: Sat, 14 Aug 2010 00:19:44 +0000
Subject: Updating Multiple rows in mysql w php at once (newbie)
Groups: php.general 
Request: Send a blank email to php-general+get-307457@lists.php.net to get a copy of this message
Hi all, another newbie question.... I have a recordset from mysql - a list of 20 or so products... 1 - I would like create an edit form to loop through the records and edit a text field called 'favorite' for each of the records - (this, I have done)... 2 - then I would like to submit the form and update all records favorite field at once... Q: so how do I create the form and response page so that I can update all 20? I'm sure it involves numbering the form names like: $c = 1 - then increment counter <input name ="favorite<?php echo $c; ?>" ... (1 - text) <input name ="favorite<?php echo $c; ?>" ... (2 - text) <input name ="favorite<?php echo $c; ?>" ... (3 - text) <input name ="favorite<?php echo $c; ?>" ... (4 - text) ...not sure how to loop thru these on the response / update page to get them updating correctly.... -- Thanks, Dave - DealTek dealtek@gmail.com [db-10]

« previous php.general (#307457) next »