Im very new to PHP and MYSQL so forgive me if my question sounds funny.
I have three MYSQL Tables, tbl_supplier, tbl_orders and tbl_payments.
I was able to successfully run a query to show which orders from a particular supplier has not been paid yet. What I want to do now is select the orders that will be paid and pass them to another Php which will print only the selected orders. I have been searching around the net and my best bet is using an array on the Where clause of my SQL Statement. However, I am confused on how to do it.
(P.S.) I am not yet allowed to post an image.
I can put a checkbox on every row to mark it as selected and then a button at the button that says, "PAY SELECTED".
When I click "PAY SELECTED", my code should get all selected invoices, query the database for the details of each item selected and return the values.
I would really appreciate your help.
CREATEstatements for each of your three tables? – Zach Rattner May 16 '14 at 5:09