displaying a image mysql (BLOB)

[ashleyxxx]

I am having trouble displaying a image from a mysql database. I am storing the image using BLOB. I am not sure what I am doing wrong?

$result = mysql_query("SELECT * FROM ae_gallery
WHERE ext='$ext'");

while($row = mysql_fetch_array($result))
{

header("Content-type: image/jpeg");
//echo $row['title'] . " " . $row['data'];
print "Image : ".$row['data'];
print '<img src="='.$row['data'].'"/>';

// echo header("Content-type: image/jpg".$row['data']);
//echo "<br />";
}
}
else
{
preg_match($vidtype,$header)!=false;

$result = mysql_query("SELECT * FROM ae_gallery

WHERE ext=''");

while($row = mysql_fetch_array($result))
{
echo $row['video_id'] . " " . $row['video'];
echo "<br />";
echo 'NO Match';
}
}
}

[NogDog]

If you are storing the actual image in the DB, then you will need a separate "image server" script that you call via an IMG tag's SRC attribute for each image, probably with the image's ID in the query string. So in your main script that is displaying the main HTML page, you would only output the <img> tag with the necessary URL for the image server script. Your image server would then only output the necessary header() values for the image type and the actual BLOB data from the DB, nothing else.