Hey ..
I am having a problem when i try to pull an image that has been stored in
MS SQL Server from displaying properly. I know, its a waste of space to
store the actual image in SQL, but this is the way it needs to be done to
be compatible with some of the other systems. Anyway, if you have any
input at all as to what could be wrong, please let me know. I will
provide my system information and code below for your review. Thanks.
Platform: Linux Redhat 9
PHP Version 4.3.1
FreeTDS 0.61 (used to connect to Microsoft SQL Server)
SQL Server 2000
Here is my code (except for connection information, of course)
<showpic.php>
<?
$eventid=$_GET[picid];
$dsource = "<SQL IP>";
$sqluser = "<Username>";
$sqlpass = "<Password>";
$catalog = "<Database>";
[EMAIL PROTECTED]($dsource,$sqluser,$sqlpass) or die("Could not connect
to the database");
@mssql_select_db($catalog) or die ("invalid");
$getpic = mssql_query("select Picture from GetPics where Id='$eventid'")
or die("Query is not achievable by SQL Server") or die("invalid");
while($rs=mssql_fetch_array($getpic))
{
header("Content-type: image/jpeg");
$image=$rs["Picture"];
print $image;
}
?>
The following is the tag inserted to my webpage:
<img src="showpic.php?picid=1">
Please let me know if you have any ideas, and if you dont, thanks for your
help anyway.
Chris
[EMAIL PROTECTED]
