Order Details page for users
I'm trying to create and order details page for the admin of schools to check for yearbook orders. I want it to query the orders based on the productID which is the yearbook for each school (session variable school_PID). So if someone logs in and their school is productID 2 then only orders with that product ID are shown. I tried to take the orders_Results page from the admin folder and rename it, and changed the Recordset but I'm getting a sql error which I've copied below. I've attached the page with what I have. Thanks
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT* FROM orderdetails WHERE DetailProductID = -1 AND (OrderShipped >= '0') ' at line 1