My problem is a little more complex but my basic problem will be the same. Using PHP and MySQL
If on a page I have a form, and I click the submit button, how do I update multiple records in a MySQL database?
Basically I have a page that pulls "time" from a table. I may have 5 "time" records for a single "client" So on this page, all "time" is shown in a repeat region for the specific "client". I click the form Submit button and a "invoice" table is filled with various information. What I need to do is take the "invoice number" from the invoice just created and Update all 5 records to show the correct invoice number in their proper fields. ..
...Make sense? On submit, I need to update multiple records with a variable.
Can anyone help me get started? I can update a record fine, it is the multiple record update that is puzzling me.