MySQL queries in Dreamweaver.?

Question

I have over 4,000 products in mySQL database, and I've successfully connected to mySQL in Dreamweaver. My product database, includes description of the product, price, image name of the products, etc. Obviously I don't want to copy and paste every single product image, description, price, on my site. How can I use queries in Dreamweaver so that I can pull all that information directly off my database?

Answer 1

well you need to set up two pages.

1) one that lists your items as URL's to "click" and will take you to the description page
2) the descrpition page - this page will receive information passed from the first page

so your list page would be something like this:
productlist.php?itemid=2

so your description page would be like this
description.php?itemid=2

that itemid=2 will determine what item's description will be displayed.

Answer 2

Do the Dreamweaver tutorials, when you are done you will be able to do this in a snap.

I expect you have MySQL on your web site so you can transfer the information from your local machine to the production server.

To get an idea of how you should present the web pages take a look at sites doing similar things. If you notice large department stores start of by Category -> Sub Category -> list of items - > Individual product page.