PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!
Moderator: General Moderators
aceconcepts
DevNet Resident
Posts: 1424 Joined: Mon Feb 06, 2006 11:26 am
Location: London
Post
by aceconcepts » Wed Feb 22, 2006 8:55 am
Hi,
I have three MySql tables 'Client', 'Product' and 'Product_Order'.
I would like to be able to display all information from each MySQL table in an html.
What is the MySql 'SELECT' syntax i use in order to make this happen?
Relationships already exist between the three tables.
Nick
chrys
Forum Contributor
Posts: 118 Joined: Tue Oct 04, 2005 9:41 am
Location: West Roxbury, MA (Boston)
Post
by chrys » Wed Feb 22, 2006 9:16 am
Do you want to display the data in one table, or you want to receive the data as one result? What's your goal
aceconcepts
DevNet Resident
Posts: 1424 Joined: Mon Feb 06, 2006 11:26 am
Location: London
Post
by aceconcepts » Wed Feb 22, 2006 10:32 am
I would like to display the data in one table.
I am able to display rows of data from one MySql table but i do not know what suntax to use in order to retrieve data from more than one table.
feyd
Neighborhood Spidermoddy
Posts: 31559 Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA
Post
by feyd » Wed Feb 22, 2006 10:42 am