finding # of item from query

[xtiancjs]

Hi , just say I have a query that goes "SELECT item_name FROM products WHERE products.drink = 'juice'" . If I get back 12 results from this query I can make a list using a simple loop, that is fine . If I click on one of these list items I want to go to a detail page, again I can do this no probs. How do I carry over to the detail page the number that the item appeared in the original list, for example if a result was "orange" and it was the 5th one in the list, how do I carry over the number 5 to the detail page?

 

thanks

[MadTechie]

you really should just pass the record ID and do another "Select ... where ID = $ID"

 

you can pass it via GET ie profile.php?id=1243 then "Select ... where ID = {$_GET['ID']}"