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

Try changing this query from:

SELECT DISTINCT ps3_orders.* FROM ps3_orders LEFT OUTER JOIN ps3_orderdetails ON OrderID = DetailOrderID SELECT* FROM orderdetails WHERE DetailProductID = %s

to

SELECT * FROM orderdetails WHERE DetailProductID = %s

I'm getting this error now.

Unknown column 'OrderShipped' in 'where clause'

I've attached the page below. Thanks

your query should be:
SELECT DISTINCT ps3_orders.* FROM ps3_orders LEFT OUTER JOIN ps3_orderdetails ON ps3_orders.OrderID = ps3_orderdetails.DetailOrderID WHERE ps3_orderdetails.DetailProductID = %s

I got it working, but when I tried to switch the template it started giving me this error.

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/content/50/7015650/html/school_orders.php:1) in /home/content/50/7015650/html/WA_ValidationToolkit/WAVT_ValidatedForm_PHP.php on line 3

Can I stick with the new template, or do I have to change it back? I've attached the file again.

Go to modify -> Page Properties.


in the title and encoding section, make sure the option to Include Unicode Signature (BOM) is not checked.