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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxx
[db-10]




[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux