17 Mar
2010
17 Mar
'10
11:15 a.m.
On Wed, Mar 17, 2010 at 10:55 AM, ukuta ken <ukutaken@gmail.com> wrote:
$connH=odbc_pconnect("myDB","me","mypassword") or die(odbc_errormsg()); $result=odbc_exec($connH, "select top 1 image from images where id='1'"); if ($result) { odbc_longreadlen($result, 131072); odbc_binmode($result,ODBC_BINMODE_CONVERT); $m_FValue=odbc_result($result, 1); header("Content-Type: image/jpeg"); echo $out=hex2bin($m_FValue); } ?>
Doesnt sybase have a 'blob' / 'var binary' field type ... ? why are you doing this conversion from hex2bin ? Why dont you store the image as binary ?