Maybe I don't understand what your need is, but here's a shot. What you want to do, I've accomplished before just by placing a field in the database which points to the image name called i.e. product_image. What this field contains, is just the name of the picture i.e. prod_001.jpg. When the *details.php* page is displayed, I just make PHP print the image like this:
// First, make array of product from DB $row = mysql_fetch_array($query); // Then show image and/or details echo "<img src=/image_folder/.$row[product_image].>"; and that's it. Like this, you just have to specify the name of each image when inserting a new product. You can also make more than one image field if needed i.e. several angles of a vehicle. Hope this helps you, C. > -----Original Message----- > From: markbm [mailto:[EMAIL PROTECTED]] > Sent: Saturday, July 06, 2002 8:35 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Retrieving/Displaying hyperlinked images with PHP > > I am trying to build a "product detail" page that pulls data from a MYSQL > database using PHP. The data for the page includes product images, which I > am trying to link to (i.e. from their location on the web server) instead > of > loading the images into the database. However, I cannot find any sample > code > that seems to work. Two questions: > > 1. Is this possible (i.e. to store the HYPERLINK to the image in the > database , and as the results are returned to the product detail screen, > the > image file will be displayed)? OR RATHER do I need to store the physical > image file in the database location and query it that way? > > 2. The code sample below contains several lines that show a field > populated > with text that I am returning....the line under the //Test comment is the > field that I'm trying to pull an image back for: > > printf("REL_PLAN7: %s<br>\n", mysql_result($result,0,"REL_PLAN7")); > printf("REL_PLAN8: %s<br>\n", mysql_result($result,0,"REL_PLAN8")); > printf("REL_PLAN9: %s<br>\n", mysql_result($result,0,"REL_PLAN9")); > > //test > printf(mysql_result($result,0,<a href="FRONT_REND">FRONT_REND</a>); > > NOTE: "FRONT_REND" is the name of the database field, and it contains a > full > web address, not relative. > > Any help would be GREATLY appreciated. Thanks. > > Mark > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
