Viewing blob images from MySQL

Verboten

I know in order to view a blob image(from mysql) you have to use the header function:
header('Content-type: image/gif');
or
header('Content-type: image/png');
or
header('Content-type: image/jpg');
and so on.
I have a problem though, I need to view the image in the middle of a page and I can't use the header function there! Is there any alternative?? I know vBulletin has done it. Thanks in advance.

EpicEro

You need to create a seperate file for pulling up your images only.
something like:

<?
@MYSQL_CONNECT("localhost", "user", "pass") ;

@mysql_select_db("my_db");
$query = "select bin_data,filetype from pictures where id=$id";
 [COLOR=green]// bin_data is the blob, filetype .jpg, .gif...[/COLOR] 
$result = @MYSQL_QUERY($query);

$data = @MYSQL_RESULT($result,0,"bin_data");
$type = @MYSQL_RESULT($result,0,"filetype");

Header( "Content-type: $type");
echo $data;

I save it as picture.php then when ever i need to pull an image out of a database is use:

and this way you can use the image like any other image!