Update one or more rows in one step.
Posted on 2011-03-04
First page queries the database for open invoices, the user selects one or more invoices and presses submit.
The second page displays the invoice numbers and the total for all invoices selected.
The user then selects the payment form and submits.
Im having trouble figuring out how to update the invoice status to paid.
SET invoice_status = '1'
SET balance = '0'
WHERE inv_id = '#FORM.invoice_id#'
How can i make it loop through all the selected invoices and update them all.