DaniWeb Forum Index > Web Development > PHP

PhP Image help

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: May 2008

Posts: 3

Reputation: WCSO-IT is an unknown quantity at this point

Solved Threads: 1

WCSO-IT

Offline

Newbie Poster

PhP Image help

May 7th, 2008

Hello all,

I have been working on a simple web app but have run into a small problem. I am still fairly new to php and have found nothing on this topic searching google. I have a getimage.php page that fetches an image from a SQL Server Express 2005 database. It seems to run fine, but when it pulls a picture, only about 1/3rd of the top is displayed. My for the getimage.php is below:

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
	$query = "SELECT INMPICTURE FROM inmates WHERE BOOKNO = '$id'";
	$result = mssql_query($query);
	$data = mssql_result($result,0,"INMPICTURE");
	header("Content-type: image/jpeg");
	echo $data;
	$query = "SELECT INMPICTURE FROM inmates WHERE BOOKNO = '$id'";
	$result = mssql_query($query);
	$data = mssql_result($result,0,"INMPICTURE");
	header("Content-type: image/jpeg");
	echo $data;

I'm hoping that it is a simple noobie mistake. Any help is greatly appreciated and thanks in advance.

•