Query 2 or More Tables MySQL PHP

[adamjnz]

Is is possible to use more than 1 table in an SQL query and if so how would you stucture it.

For example I am doing this site where there a 5 products and users log in to stock up on these products. The products are stored in a table along with a description and a path to a picture of the product. There is a second table that lists each product once for each user and stores that users buy price and mimimum stock qty.

I want to make a query that I can display the name, description, picture etc of each product that that user sells, but show it with their buy rate and minimum qty.

What is the best way to approach this?

I will be using the <? do { } while .... ?> thing to display each product on the order page.

[bustamelon]

use a JOIN

http://www.w3schools.com/sql/sql_join.asp

[angst]

ok, you could just use something like:

mysql_query("SELECT u.firstname, f.message FROM users u, forum f WHERE u.ID = f.UserID AND u.name='adam'");


hope this helps,
-Ken