Product table through to item listing
Not sure if this belongs in PHP or mySQL
I looking for some pointers in how this is carried out.
I have a html table that is populated from a mySQL database. What I want to do is that when you click on a product in the table it takes you to a product page that is filled out by fetching that specific products details.
So using a common template, if say "apples" is clicked on, it would load up the common template, and fill in all the detail from the SQL database about that product "apples"
What Im not sure on if how to make it fetch only the product info for what has been selected
Any help would be hugely appriciated