Linking To A Single Product Page

[justlukeyou]

Hi,

 

I have a database which can echo a range of products and I have a page which will echo 1 single product.  However, these are completely seperate.

 

Can someone please advise how I can link from a multiple list of products onto a single product page?

[Barand]

put a link on eachitem

 

http://www.w3schools.com/tags/tag_a.asp

[justlukeyou]

Thanks,

 

So on the multiple products page I need to create a query link which has the ID echoed into it (product.php?='echo ID') ...something like that.

 

So lets say the cheapest item is ID 222 this will be first item if I sort it by cheapest item.

 

How do I tell the single product page that someone has clicked on ID 222.

 

Do you use a GET command to get the chosen ID from the multiple product page?

[Barand]

If the link is like this

 

<a href='product.php?id=222'>Widget</a>

 

then in product.php

 

$prodId = $_GET['id'];

 

[justlukeyou]

Brilliant thanks.

 

"$prodId"  what does prodId relate to.  I was planning to create a row in the MySQL database with ID and increments by 1 for each new entry and call it "ID"

 

Is it best to call it prodId?

[Barand]

Just a variable name, any will do.

 

I was merely demonstrating how you get the value of id from the querystring using the $_GET array