updating multiple records from one form
Posted: Tue Sep 06, 2005 2:58 pm
Hi All!
I'm looking for some help with what seems like a simple request, but as usual never is. I have a client that runs a tree nursery. We've set up the webstie and content manangement for them, but I need to be able to update the price list of each plant from one table. I can show all the plants and their prices, but can't figure out how to update with the one form. I can update the prices one by one, but that takes the client forever. They would like to see a list of plant names and prices, then be able to make the changes and then click update and have all the different records be updated. Make sense? If anyone has any ideas or suggestions that would be greatly appreicated. (This is php and MySQL code I'm looking for)
Thanks
Shelley
I'm looking for some help with what seems like a simple request, but as usual never is. I have a client that runs a tree nursery. We've set up the webstie and content manangement for them, but I need to be able to update the price list of each plant from one table. I can show all the plants and their prices, but can't figure out how to update with the one form. I can update the prices one by one, but that takes the client forever. They would like to see a list of plant names and prices, then be able to make the changes and then click update and have all the different records be updated. Make sense? If anyone has any ideas or suggestions that would be greatly appreicated. (This is php and MySQL code I'm looking for)
Thanks
Shelley