images

Anon

I have a field in my mysql db named icon that sores image pathnames like so... /images/africa/KEN11-285Elephant.jpg

my php to pull them out looks like this...
printf("<tr><td bgcolor=#C0C0C0>%s</td><td bgcolor=#C0C0C0>%s</td><td bgcolor=#C0C0C0>%s</td><td bgcolor=#C0C0C0>%s</td><td bgcolor=#C0C0C0>%s</td><td bgcolor=#C0C0C0>%s</td></tr>\n",
$myrow["trp_name"], $myrow["region"], $myrow["country"], $myrow["description"], $myrow["cost"], "<a href='more_info.php?trip_id=$trip_id'>More Info</a>", "<img src=$myrow["icon"]>");

But I am getting the following error...
Parse error: parse error, expecting T_STRING' orT_VARIABLE' or `T_NUM_STRING' in /usr/local/etc/httpd/htdocs/idema/New_site/take_out/search_options3.php on line 42

Can anyone tell me why? I need some assistance.

Anon

seems you " are out of place.
the ending of your line should read as follows:
"<a href='more_info.php?trip_id=$trip_id'>More Info</a><img src=" $myrow["icon"] ">");

possum wrote:

I have a field in my mysql db named icon that sores image pathnames like so... /images/africa/KEN11-285Elephant.jpg

Can anyone tell me why? I need some assistance.

Anon

no. I already attempted that. Thanks anyway.

Anon

Try changing:

"<img src=$myrow["icon"]>");

"<img src='" . $myrow["icon"] . "'>");

Anon

So frustrating!!! It seems so simple. It is working for me when I print out an individual image but won't display numerous images!!!

working->

printf("<tr><td bgcolor=#C0C0C0>%s</td></tr>\n",
"<img src=images/ME.jpg>");

not working->

printf("<tr><td bgcolor=#C0C0C0>%s</td><td bgcolor=#C0C0C0>%s</td><td bgcolor=#C0C0C0>%s</td><td bgcolor=#C0C0C0>%s</td><td bgcolor=#C0C0C0>%s</td><td bgcolor=#C0C0C0>%s</td></tr>\n",
$myrow["trp_name"], $myrow["region"], $myrow["country"], $myrow["description"], $myrow["cost"], "<a href='more_info.php?trip_id=$trip_id'>More Info</a>", "<img src='" . $myrow["icon"] . "'>");

Anon

try just to print out the value for $myrow["icon"]
and see if you get a proper result ... it can also be that your column name is case-sensative there-fore not finding the column "icon")

Anon

Finally got it. I used

"<img src=".$image_path."/".$myrow["icon"].">"

Anon

what is the inssert in mysql for $image_path and what is the insert for $myrow["icon"]