Updating Multiple rows in mysql w php at once (newbie)
| From: | DealTek | 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]