[RESOLVED] longblob problem

neroag

Hi Guys
I have a table named "pictures" with fields.. "id", "account_number","picture"
i can store photos in this database without any problems but im having problems retreiving the information with the following snippet, it only displays the binary data & not the photo.

if anyone could help it would be appreciated.

Thanx everyone

<?
require('config.php');
mysql_connect($dhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM pictures WHERE account_number = 62";
$result=mysql_query($query);
$picture = mysql_fetch_array($result); 
echo $picture['picture']; 
$num=mysql_numrows($result);
mysql_close();
?>

Weedpacket

You'll need to send the appropriate Content-Type: [man]header[/man] so that the browser knows what to do with the data (if you don't specify a Content-Type, PHP uses the default of text/html, and so that's how the browser tries to render it).

neroag

Hi thanx for that ive tried it as ...

<? 
require('config.php'); 
mysql_connect($dhost,$username,$password); 
@mysql_select_db($database) or die( "Unable to select database"); 
$query="SELECT * FROM pictures WHERE account_number = 62"; 
$result=mysql_query($query); 
$picture = mysql_fetch_array($result);
header('Content-Type: image/gif');
echo $picture['picture']; 
$num=mysql_numrows($result); 
mysql_close(); 
?>

but i just get the old Warning: Cannot modify header information - headers already sent by error no matter where i place it in the script.

saraadmin

Is it your own config.php file? Are you sure its not sending some information to the response?

neroag

Yes its my own config file & the snippet is part of a larger script that im using
it works if i put the snippet at the top of the script before any other output, problem is i need it further down the script after other output from other parts of the script

if that makes sense lol

saraadmin

Are you using HTML?

If so, then you could remove your image generating PHP to a single, tiny script which just returns an image (with appropriate HTTP headers) and "insert" images using IMG tags:

<?php ... ?>
<img src="http://domain.net/my_image_getting_script.php?image_id=<?= $image_id ?>" />
<? ..... ?>

neroag

hmmmm now theres a point lol

thanx saraadmin, appreciate your input