xtiancjs Posted May 6, 2007 Share Posted May 6, 2007 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 Quote Link to comment https://forums.phpfreaks.com/topic/50269-finding-of-item-from-query/ Share on other sites More sharing options...
MadTechie Posted May 6, 2007 Share Posted May 6, 2007 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']}" Quote Link to comment https://forums.phpfreaks.com/topic/50269-finding-of-item-from-query/#findComment-246741 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.