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
