Help! updating multiple tables on same page?

[BrianDickson]

Hi all

I'm using Dreamweaver MX to develop a PHP/mySQL database.

I currently have a page which displays related information from various tables via multiple recordsets. How do I use an update page to update more than one table on the same update page? (I want to keep the same formating on the update page as with the display page).

Thanks
Brian

[paulnaj]

Have one update form per database table. You can have as many as you like on an HTML page.

Include a hidden form field in each form that describes the table to be updated. This will get passed back to the page on submitting.

Use a switch() statement or if ... else if ...else to decide which table to update.