germayne Posted December 13, 2006 Share Posted December 13, 2006 Help!! :-[I do not know how to go about retrieving the image url from the database. In the database, I have created a product table which stores the product names, descriptions, prices, image url etc. And I want to display the product thumbnails in the website with its name and price. When I click on the thumbnail I want, it would go to another page that describes the product further. An example would be http://www2.victoriassecret.com/collection/?cgname=OSCLOALSZZZ&cgnbr=OSCLOALSZZZ&rfnbr=2406I have the first step done which is storing my image urls. So what do I do next? How do I 'call' the image url? How's the code like? I am very new to php and mysql. Any help would be greatly appreciated! :D Link to comment https://forums.phpfreaks.com/topic/30435-newbie-help-how-to-retrieve-image-url-from-database/ Share on other sites More sharing options...
trq Posted December 13, 2006 Share Posted December 13, 2006 Read [url=http://hudzilla.org/phpwiki/index.php?title=Databases]this[/url]. Link to comment https://forums.phpfreaks.com/topic/30435-newbie-help-how-to-retrieve-image-url-from-database/#findComment-140139 Share on other sites More sharing options...
germayne Posted December 14, 2006 Author Share Posted December 14, 2006 Thanks thorpe! :DRead through the website but I still don't quite understand. :(Actually I manage to retrieve the image and info for prod id 1 but when I did the same for prod id 2, the image and info appear to be that of prod id 1. Which means it keeps repeating the same record. What I did was, I set a recordset.. select the relevant fields and click on insert at the bottom of the Binding panel. Then I click on the dynamic text and in the Link field of the Property inspector, enter a text string. After which, I click the <a> tag, click prod_id field in the Bindings panel, choose a.href in the Bind To drop-down menu at the bottom of the panel, and click the Bid Button. Lastly, in the Link field of the Property inspector, I added [i]profiles_detail.php?prod_id=pfl01 [/i] right at the beginning. It works.. but only prod_id [b]pfl01[/b] manage to display. Is there anything wrong with what I did? Any ways to salvage the situation? I hope I don't need to do it from scratch again. :-\ Link to comment https://forums.phpfreaks.com/topic/30435-newbie-help-how-to-retrieve-image-url-from-database/#findComment-140973 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.