Images in an sql table

Soldato
Joined
1 Dec 2004
Posts
22,552
Location
S.Wales
Im trying to get display output from my catalogue (SQL table)

in the table i have created a field called "image" the datatype of this field is text (or tiny text) , inside for each item a url is entered in the image field

"http://www.blahblahblah.com/blah/blah/111.jpg"

the table is then updated with this information..

in the php then i have a div which contains all fields and their results. i have included the image field in this..

see code below

Code:
$catagory=mysql_result($result,$i,"catagory");
$title=mysql_result($result,$i,"title");
$price=mysql_result($result,$i,"price");
$image=mysql_result($result,$i,"image");


echo '<div align="left" class="catagoryleft">';
echo "<b>Catagory: </b> $catagory <br></br>
<b>Title: </b>$title <br></br>
<b>Price: </b> $price<br></br><br><img src='.$image.' />";
echo "</div>";

its does not seem to want to display the image output, the page loads with no errors but no image has been loaded.

is the code correct or am i going the wrong way?
 
Back
Top Bottom