images & mysql

[Anon]

Hello all. So I have been told that the best way to go about having images in your database is to not actually have them stored there but to save the filename as a reference to another location on the server where the images are saved. Ok... but how do I get the images to output in the browser? Right now the db is returning the filename as it appears in the db field. How do I make that filename actually reference the image so it gets displayed?

[azurem]

Try something like this:

Open your database. Do the query to get your image name. Then stick it in an <img src=""> tag as follows:

$result = mysql_db_query ($database,"SELECT * FROM images WHERE (((ID)='1'))");
$row = mysql_fetch_assoc ($result);

echo("<img src=".$image_path."/".$row["image"].">");