I hope I am writing this to the correct forum. I am a beginner at webdesign.
I am using Dreamweaver CS3 to design php pages.
I have created a page that calls from the MYSQL database (among other things) the names of all the products.
I have created a page that calls all the descriptions of the products. By the way, the descriptions and the product names are two different columns in the same db table.
My problem is that when I link the products field to the description and I view in Browser and click on a particular product the whole of the descriptions appear rather than just the description of the product in question.
I am sure their is a simple fix but it sure eludes me
Thanks for any help
You are talking about a master/detail relationship. Are you using the master/detail server behaviors? Basically, the master pages lists all of the products by name. When the visitor selects a product, the product ID (or whatever uniquely identifies the product) is passed to the detail page. This ID is then used in the where clause of a sql query to filter the results to the single product details.
You have pointed me in the right direction.