Displaying data from more than one table

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

Post Reply
User avatar
aceconcepts
DevNet Resident
Posts: 1424
Joined: Mon Feb 06, 2006 11:26 am
Location: London

Displaying data from more than one table

Post by aceconcepts »

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
User avatar
chrys
Forum Contributor
Posts: 118
Joined: Tue Oct 04, 2005 9:41 am
Location: West Roxbury, MA (Boston)

Post by chrys »

Do you want to display the data in one table, or you want to receive the data as one result? What's your goal
User avatar
aceconcepts
DevNet Resident
Posts: 1424
Joined: Mon Feb 06, 2006 11:26 am
Location: London

Post by aceconcepts »

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.
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

Post Reply