Newbie in need of serious help

[Woptastic]

Here is the problem. I have a php page that will display various links such as chairs, couches, tables and such. Chairs has been given an id of 1 couches 2 and tables 3 and such. I have a database in which there are 2 tables, Product which contains id, SupProdID, SupID, ProdName, ProdDesc, ProdPrice. Supplier contains SupID, SupName, SupCity, SupState, SupZip, SupPhone, SupWeb. When a user clicks on chair (id 1)it should pull out all the records in the product table with all records id 1 as well as the supplier information. However I can not get this to happen. Can someone please give me as much guidance as they can.

[Elena Mitovska]

To retrive data from 2 table by one select query you eed to use LEFT OUTER JOIN or INNER JOIN constractuins of MySQL.
If every record in yuor Product table has its match in Supplier table use INNER JOIN, if it doesn't use LEFT OUTER JOIN. INNER JOIN fetches only those records that has its math in other table (matched by SupID)
For example, this quiery retrives information about both Product and Supplier from both tables:

Select distinct P.*, S.* from Products P LEFT OUTER JOIN Supplier S ON P.SupID=S.SupID WHERE P.SupID=......

Hope it helps

[Woptastic]

What would that look like in php?