Linking to a product in the database

[purgero]

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

[Ray Borduin]

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.

[purgero]

Ray,

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

Thanks

[Ray Borduin]

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?

[purgero]

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.

[Ray Borduin]

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.

[purgero]

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

[Ray Borduin]

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?

[purgero]

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

[Ray Borduin]

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

[purgero]

Ray, where exactly do I tell it which product to show in the results? I want it to show item # 2034. Where do I tell it to show that one?

[Ray Borduin]

Products_Detail.php?ProductID=2034

[purgero]

I figured it out.

The productID is 31. I put it in, and it showed up.

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

Thanks for all your help.

Paul

[Ray Borduin]

You can get rid of: <?php echo $row_rsProducts['ProductID']; ?>

it is obviously doing nothing.