Linking to a product in the database

On the home page, I want to link one of the thumbnails to a particular product. I've created a recordset for the "products".

Here is my code...where do I tell it the particular item number?

<a href="/Products_Detail.php?<?php echo $row_rsProducts['ProductID']; ?>=<?php echo $row_rsProducts['ProductID']; ?>"><img src="Images/featured_1.jpg" alt="Placeholder" style="float:left; margin-right:10px;" /></a>

Thanks
Paul

It should be:

<a href="/Products_Detail.php?ProductID=<?php echo $row_rsProducts['ProductID']; ?>">

and then you can use $_GET['ProductID'] to reference the product on the product details page.

Ray,

Can you send me a link to somewhere that I can see exactly how it is done with your extensions?

Thanks

This isn't actually done with our extensions. This is just a common php and Dreamweaver concept.

Our extensions don't help you add a url parameter to a link, or to filter a recordset by a url parameter... that is built in DW functionality and a common concept throughout all server languages not just php.

Where do you get stuck? Adding the parameter? Filtering a recordset with the parameter?

i can get the results page to be linked and come up...but it is how to get the exact product to show in the results page. i guess it is basic stuff.

thanks.

Open up the recordset in Simple view

Then choose from the filter dropdown to filter by the url parameter and type in the name of the parameter you are using.

Ray,

Thanks...when I tested it in Simple view, it showed the correct item. But when the details page opened, it showed no results. Here's the code:

<p><a href="/Products_Detail.php?ProductID=<?php echo $row_rsProducts['ProductID']; ?>"><img src="Images/featured_1.jpg" alt="Placeholder" style="float:left; margin-right:10px;" /></a></p>

Thanks

What does the url look like when you click on it in the browser? Does it look correct there? Are you using the same exact parameter name "ProductID" case sensitive?

When the results show up, or even when I hover over the original link, it shows the following:

Products_Detail.php?ProductID=

So somehow, somewhere, I have the ID in the wrong place.

When I go into the recordset (rsProducts), I have the Products Table, with ALL the columns selected. The filter is: ProductID =, the URL Parameter is 31 (which is the ProductID that I want), and Sort is NONE.

When I test it, it shows fine, but it doesn't come up on the details page, or in the link on the home page.

Thanks

That means the problem is with the code linking to the page:

<a href="/Products_Detail.php?ProductID=<?php echo $row_rsProducts['ProductID']; ?>">

specifically:
<?php echo $row_rsProducts['ProductID']; ?>

that column reference or database reference must not be correct....

when it works the url will look like:
Products_Detail.php?ProductID=27