problem in reading imge from sqlserver
my code is:
<?php
include('conect.php');
$query="SELECT file_name, file_size, file_code, file_type, file_des
FROM graph";
$reult=mssql_query($query,$link);
while($row=mssql_fetch_array($reult))
{
$fp=fopen($row['file_name'],"wb");
$file=fwrite($fp,$row['file_code']);
print"<img src=\"".$row['file_code']."\">";
}
?>

Though I am not an expert in PHP (decent way of saying that I haven't worked on that :) ) ... I guess one can't retreive fields in an arbitary fachion when it comes to fields of Image/Text datatypes. If my memory is right i think image/text datatype columns needs to be at the end of the selection list.

Best Regards
Vadivel

MVP ASP/ASP.NET
http://vadivel.thinkingms.com

Yes, Vadivel you are correct. The fields of binary type has to be at the end of the fields list used in select statement.

In order to make them fast, I usually fetch binary fields in a seperate stored procedure. You may try that also.