ooordinating order details with order items?
Hi Ho Ray. Almost there. So, when I check on orders_search, it pulls up all orders and shows name , amount, etc, but not the products that were ordered or quantity. the way the tables were created in the DB I have orders as one table and orderdetails as the second. The order ID is the same for both. But if the client wants to look up the order for the customer,. they can't see the items or quantities. I thought eCart would sync them when it created them in the details page. It also seems to be putting the wrong product Id in the detail area. It was putting in the product id before (see order #3). I created another recordset on the details page to the order details table of the items, but I don't see a way to link the query in the server behaviors to the other table. I.e., to link the query to the OrderID numbers.
would a query like this work?>
$OrderDetails = new WA_MySQLi_RS("OrderDetails",$DealersSupplyCo,1);
$OrderDetails->setQuery("SELECT * FROM orderdetails WHERE $WADAorders_details (orders.OrderID = DetailOrderID) ");
$OrderDetails->execute();
My syntax may be way off.