How do I display data from multiple tables?
Posted: Wed Aug 24, 2005 11:34 pm
I know how to query two tables for the data I'm looking for, but I don't know how to display it. One table has customer information, the other table has orders placed by the customers.
I'm using this query:
SELECT customers.realname, orders.product FROM customers, orders WHERE customers.realname=orders.realname;
now do I write a WHILE statement?
How to display the data on a page?
looing to display it like this:
Customer:Product
Customer:Product
Customer:Product
All help much appreciated!
I'm using this query:
SELECT customers.realname, orders.product FROM customers, orders WHERE customers.realname=orders.realname;
now do I write a WHILE statement?
How to display the data on a page?
looing to display it like this:
Customer:Product
Customer:Product
Customer:Product
All help much appreciated!