Thak you for your response. I do have a few problems. First off my Order_id in the store summary was left blank.( was following cart documentation) The order reference ID has this session variable: <?php echo session_id(); ?> ( Idont know what the reference ID is for again was following the ecart doucumentaion, In the database its a long number like this: dad0f24d68114838c0b7f1a090dafcd2 ). Should i have a session variable value there for the order ID in the store summary and if so what should i put. The database is auto incremented and that order ID is the primary key. In the details table for detail_Order ID in the store cart details this is my value: <?php echo ((isset($_SESSION["eCart1_OrderID"]))?$_SESSION["eCart1_OrderID"]:""); ?> . Also when making the recordset how would I add a session variable in the sql query. I seem to always a get a mysql error: 1064 error for example
FROM orders INNER JOIN detail_table ON orders.OrderID = detail_table.details_orderID
WHERE orders.OrderID = <?php echo session_id(); ?> . Do I need to add variables? What do I do?