listing db content as a form.. need to make each unique with array.. ??

[jwk811]

I have products shown in my admin pages and they are shown listed in a form so each detail (price, name, etc.) is shown as a text input.. if i do this they will all have the same name when i submit it to update.. i figured i could make it an array somehow and then use foreach or implode to get it all and update it to the db like that.. understand? any help? thanks!

[Yesideez]

Not sure I understand that at all...

[Jessica]

In the form, you need to associate each detail with the ID, then do a WHERE id=$id in your update. It's probably easiest to only let them update one at a time.

[jwk811]

lol sorry.. ill try to make it sound better.. i have a table on my db for products which includes name, price, etc... i have admin pages where i can set the price of each item.... in that page i need it to list all my products that i have saved into my db... to get the products on that page i do a mysql query to select everything in the table and then use

while($row = mysql_fetch_assoc($result)){
extract $row;

that way i now have the name and price of all my products and it will execute this code for all the products

<input type="text" name="name" value="<?php echo $name; ?>">

and same for the price.. since it will show all these products like this they will all have the same name and that wont work when i try to update it to the db. i was wondering if it would be possible to use an array to make each unique and i need to know how to submit it to the db afterwords

[jwk811]

It's probably easiest to only let them update one at a time.

 

your right thats probably the best way to do it, thanks