Displaying images in mysql 2

[sheister]

I have images stored in my database in mysql, and i was wondering if anyone knew how to display them in my webpage.
In dreamweaver, only some images display and others don't, even thought they're the same size and dimensions.

This is my code in php:

<td>&nbsp;<img src="images/<?php echo $row_rs_image['Img_Hotel1']; ?>" alt="Image" width="150" height="150"></td>

Any help would be greatly appreciated.

 

[jpadie]

the img tag takes a url as a src attribute. this should normally point at a php script that delivers the relevant image header together with the binary contents of an image. typically the src attribute takes a query string in order to identify the image that you want to serve. there are plenty of examples in this forum.

 

[overflo]

I always store the images on the server and only the path (and perhaps title) in the database then when you call the row and assign a variable to it you only need to do this

echo <img src=$pathoimage title=$title alt=$title />

 

[ljwilson]

I totally agree with overflo, it is much more efficient and less processor intensive to store the pointer to the image file in your MySQL table.

LJ