Instead of: echo "<img src=http://www.website.com/images/".$result[FRONT_REND].";>";
Wouldn't you want it to be: echo "<img src='http://www.website.com/images/"; . mysql_result($result, 0, 'FRONT_REND') . "'>'; ...? miguel On Sun, 7 Jul 2002, markbm wrote: > Thanks for the reply. The question is how to pull that hyperlink/file > location and display the image file on a PHP page. Basically, the text in > the FRONT_REND field is just an image name (1855.jpg), and I store the > prefix to that location on the page. I have included all the code from my > page below....the issue at hand is noted by //Problem Area//. Note also, > that all fields above this item are simply just retrieving text from a db > field not retrieving a file from the db/web server location. Again, thanks > for your help. > > CODE: > =============================================== > > <body> > > > > <?php > > > > $db = mysql_connect("localhost", "username", "password"); > > > > mysql_select_db("dbname",$db); > > > > $result = mysql_query("SELECT * FROM PRODUCTS",$db); > > > printf("ID: %s<br>\n", mysql_result($result,0,"ID")); > printf("HPG_PLAN_ID: %s<br>\n", mysql_result($result,0,"HPG_PLAN_ID")); > printf("DESIGNER: %s<br>\n", mysql_result($result,0,"DESIGNER")); > printf("PLAN_NAME: %s<br>\n", mysql_result($result,0,"PLAN_NAME")); > printf("EXTERIOR: %s<br>\n", mysql_result($result,0,"EXTERIOR")); > printf("NUM_BEDROOMS: %s<br>\n", mysql_result($result,0,"NUM_BEDROOMS")); > printf("NUM_BATHS: %s<br>\n", mysql_result($result,0,"NUM_BATHS")); > printf("NUM_FLOORS: %s<br>\n", mysql_result($result,0,"NUM_FLOORS")); > printf("GARAGE: %s<br>\n", mysql_result($result,0,"GARAGE")); > printf("NUM_CARS: %s<br>\n", mysql_result($result,0,"NUM_CARS")); > printf("FOUNDATION: %s<br>\n", mysql_result($result,0,"FOUNDATION")); > printf("MAT_LIST: %s<br>\n", mysql_result($result,0,"MAT_LIST")); > printf("COLOR_REND: %s<br>\n", mysql_result($result,0,"COLOR_REND")); > printf("PICTURES: %s<br>\n", mysql_result($result,0,"PICTURES")); > printf("REPRODUCIBLE: %s<br>\n", mysql_result($result,0,"REPRODUCIBLE")); > printf("RR_REVERSE: %s<br>\n", mysql_result($result,0,"RR_REVERSE")); > printf("MIRROR_REV: %s<br>\n", mysql_result($result,0,"MIRROR_REV")); > printf("CAD_FILES: %s<br>\n", mysql_result($result,0,"CAD_FILES")); > printf("BONUS_ROOM: %s<br>\n", mysql_result($result,0,"BONUS_ROOM")); > printf("WIDTH: %s<br>\n", mysql_result($result,0,"WIDTH")); > printf("DEPTH: %s<br>\n", mysql_result($result,0,"DEPTH")); > printf("HEAT_SQ_FT: %s<br>\n", mysql_result($result,0,"HEAT_SQ_FT")); > printf("UNHEAT_SQ_FT: %s<br>\n", mysql_result($result,0,"UNHEAT_SQ_FT")); > printf("TOTAL_SQ_FT: %s<br>\n", mysql_result($result,0,"TOTAL_SQ_FT")); > printf("ROOF_TYPE: %s<br>\n", mysql_result($result,0,"ROOF_TYPE")); > printf("ROOF_PITCH: %s<br>\n", mysql_result($result,0,"ROOF_PITCH")); > printf("SEC_ROOF_PITCH: %s<br>\n", > mysql_result($result,0,"SEC_ROOF_PITCH")); > printf("MAIN_CEIL_HEIGHT: %s<br>\n", > mysql_result($result,0,"MAIN_CEIL_HEIGHT")); > printf("PLAN_DESCRIPTION: %s<br>\n", > mysql_result($result,0,"PLAN_DESCRIPTION")); > printf("REL_PLAN1: %s<br>\n", mysql_result($result,0,"REL_PLAN1")); > printf("REL_PLAN2: %s<br>\n", mysql_result($result,0,"REL_PLAN2")); > printf("REL_PLAN3: %s<br>\n", mysql_result($result,0,"REL_PLAN3")); > printf("REL_PLAN4: %s<br>\n", mysql_result($result,0,"REL_PLAN4")); > printf("REL_PLAN5: %s<br>\n", mysql_result($result,0,"REL_PLAN5")); > printf("REL_PLAN6: %s<br>\n", mysql_result($result,0,"REL_PLAN6")); > 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")); > > //Problem code // > > // Then show image and/or details > echo "<img src=http://www.website.com/images/".$result[FRONT_REND].";>"; > > > //printf("FRONT_REND: %s<br>\n", mysql_result($result,0,'<a > href=FRONT_REND></a>')); > printf("REAR_REND: %s<br>\n", mysql_result($result,0,"REAR_REND")); > printf("SIDE_REND1: %s<br>\n", mysql_result($result,0,"SIDE_REND1")); > printf("SIDE_REND2: %s<br>\n", mysql_result($result,0,"SIDE_REND2")); > printf("THMBNAIL_IMG: %s<br>\n", mysql_result($result,0,"THMBNAIL_IMG")); > printf("FLRPLAN_1: %s<br>\n", mysql_result($result,0,"FLRPLAN_1")); > printf("FLRPLAN_2: %s<br>\n", mysql_result($result,0,"FLRPLAN_2")); > printf("FLRPLAN_3: %s<br>\n", mysql_result($result,0,"FLRPLAN_3")); > printf("OTHER_IMG1: %s<br>\n", mysql_result($result,0,"OTHER_IMG1")); > printf("OTHER_IMG2: %s<br>\n", mysql_result($result,0,"OTHER_IMG2")); > printf("NUM_HITS: %s<br>\n", mysql_result($result,0,"NUM_HITS")); > printf("PAYPAL_BUTTON: %s<br>\n", mysql_result($result,0,"PAYPAL_BUTTON")); > > > > > > ?> > > > > </body> > > "Miguel Cruz" <[EMAIL PROTECTED]> wrote in message > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > On Sat, 6 Jul 2002, markbm wrote: > > > 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? > > > > It's obviously much easier to store the link or the file name in the > > database. In fact, it's so easy that I can't guess offhand what aspect of > > it you might be having trouble with. Perhaps you could show some more code > > and explain the symptoms you are observing. > > > > miguel > > > > > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
