Updating Multiple rows in mysql w php at once (newbie)
[email protected] (DealTek)
| Newsgroups | php.general |
|---|---|
| Message-ID | <[email protected]> |
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 [email protected] [db-10]