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.