load images from db

[rtown]

quickie for ya...
got a template page, on requested link from another page, it sends variable to the template page to create content that is pulled from a db. my query is pulling the right data, but I can't get the image to show, not sure if it is my usage of the variable in the img tag???

<?php
include("../php/includes/db.inc");
if (isset($GET['page_name'])) {
$page_name=$GET['page_name'];
$sql=@("SELECT img_1,img_2,img_3 FROM pages WHERE page_name = '$page_name'");
$a_row=mysql_fetch_array($sql);
$img_1= $a_row["img_1"];
$img_2= $a_row["img_2"];
$img_3= $a_row["img_3"];
//echo "$page_name,$img_1,$img_2,$img_3";
}
?>
<table border="0" cellspacing="0" cellpadding="0" width="518" height="50">
<tr>
<td align="right" valign="top" height="1"><img border="0" src="$img_1" width="213" height="122">
</td>
<td width="299" rowspan="2" height="50"><img border="0" src="$img_2" width="285" height="348">
</td>
</tr>
<tr>
<td align="right" valign="top"><img border="0" src="$img_3" width="213" height="226">
</td>
</tr>
</table>

the link from the sending page just looks like this:
<a href="../productline/template.php?page_name=od_about"....>

and I stored the path to the images in the db not the image itself so it is stored as such (minus the whatever):
img_1=../odyssey/images/whatever.gif
img_2=../odyssey/images/whatever.gif
img_3=../odyssey/images/whatever.gif

the paths are correct, so I am stumped...any ideas?

[stolzyboy]

change this

$a_row=mysql_fetch_array($sql);
$img_1= $a_row["img_1"];
$img_2= $a_row["img_2"];

$img_3= $a_row["img_3"];

to this

while($a_row = mysql_fetch_array($sql)
{
$img_1= $a_row["img_1"];
$img_2= $a_row["img_2"];
$img_3= $a_row["img_3"];

}

[nnichols]

The parser is in HTML mode at that point in your script so it should be printing "$img_1" as the img source.

You need to use something like -

src="<? echo $img_1; ?>"

Hope this helps 😉

[rtown]

no dice, I even spent some time messing around with the paths to the files...but to no avail...i am stumped.

i tried my variable being src"../$img_1" and then having the db read odyssey/images/pic, but didn't work? are there any querky side notes about using img paths in a db that I am missing, they are stored as a varchar does that matter, i dunno just diggin?

[nnichols]

There are no quirkes with this.

What does it print in the HTML when you read the source?

[rtown]

nnichols...
didn't see your post til I sent my reply to Stolzy, but your idea worked...thanks a million dude. I got a pile of hair on the floor beside, now that I have this figured I am gonna go find some glue. Thanks again!!!!!!!!!!!!!!😃

[stolzyboy]

ah crap, didn't even notice you weren't in php, most people echo out the whole thing, that is why i didn't notice it, nice to see that people are getting out of the echo everything like perl problem