Get ready for BLACK FRIDAY shopping starting in

Forums

This topic is locked

Menu linking

Posted 11 Feb 2006 18:22:47
1
has voted
11 Feb 2006 18:22:47 Alan Pounds posted:
Hello,
I'm semi-new to Dreamweaver 8 and I'm trying to link a hef to a category of products in my database. I'm using PHP & MySQL. Example: In my navigational bar I'm selling pillows, pillow covers, mattress covers etc. When I click the pillows link I want to see only my pillows. I've got my database setup with the following fields: ProdID, ProdName, ProdDesc, ProdPrice, ProdSKU, ProdCatID, ProdWeight and I've got my table setup with a repeat region and I see all my records at once. How do I set it to see just that product when I click on that category?

Thanks
Alan

Replies

Replied 23 Feb 2006 08:30:31
23 Feb 2006 08:30:31 Diego Fonseca replied:
Well man, to show just one product in a page from a Repeat Region you have to create a page with a specific name for that action, call it, "Product Detail Page (ASP , PHP)" for example, and then try to create in mySQL a new table with the categories (Pillows, Mattress, covers, etc).

Ok, In your Product Page (Design View) marks your Repeat Product list (Pillows in this case) and go to the Application insert bar, There you´ll find a Tab named "Go to detail page", well linked the Pillows to this option, The "Go to Detail Box" appears, In the first field DW automatically shows the Link, It´s your Product.ProdName or whatever you called it, in the second field navigate in your site´s folders and linked to your Product Detail Page (Pre-designed), In the "Pass Url Parameter", choose prodCategory (The newly you created in mySQL, or to your prodID, or the Key for your product list (This is critical), In "Record Set", choose the Record Set from where you get that information, and finally in "column" choose prodID, (Try to check it out all the options from this DW Action and you´ll be able to accomplish your request). DW knows that within this link (Go to detail page) you trying to get information exclusive for this ProdID, and your Product Detail Page will show it as you want, of course you have to built the Detail Page for example with the information you need to be displayed like the product´s image, description, price, etc, or Categories if you want. Excuse my english.
Replied 23 Feb 2006 08:37:44
23 Feb 2006 08:37:44 Diego Fonseca replied:
Sorry man, In PHP pages you can´t use the "GO TO DETAIL PAGE", if i figure out how to do it, I´ll post it.

Reply to this topic