Hello, I am trying to create a shopping cart for my company and have hit a snag.
I have created a database in MySQL that has several tables. How would I go about displaying the fields from one table based on the fields in the other? Let me explain. I have a table called forder_details which contains the following fields. It has the ordernumber, the productid and the quantity. When a customer puts an item in the cart, it inserts this information into the forder_details database. EXAMPLE: Orderno productid qty 325505 27 3 Everything works fine except when it comes time to display the items in the cart. How do I need to go about telling the cart display page that productid 27 is really an apple and the cost is $1.00 and so on. I will need to do the select on the cart based on a session that contains the order number. I will also need to loop through all of these items as well. Thanks in advance. Chris --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php