R: [PHP-DB] Image + Database + Html + HELP

try header ("Content-Type: image/jpg"), and then print what is in your long raw field. P.S.: I see you use OCIPLogon, OCI Permanent Logon: how do you pass Logon between pages? Do you pass variable $conn? Ciao Roberto > -----Messaggio originale----- > Da: Serkan AKCIN [mailto:serkan@baskent.edu.tr] > Inviato: giovedì 31 agosto 2000 14.38 > A: php-db@lists.php.net > Oggetto: [PHP-DB] Image + Database + Html + HELP > > > We store JPG files in a LONG RAW column of Oracle. > Above code query the jpg table. But How can I show it on the browser? > I need help! help! help! > Ex: > <html> > <head><title>Image&Database&HTML</title></head> > <body> > <?php > $conn= OCIPLogon("user","pass","host"); > $sql = "select jpgimage from tbljpg where jpgid=1"; > $stmt = OCIParse($conn,$sql); > if (!OCIExecute($stmt)) { print "execution failed"; exit(); } > OCIFetchInto($stmt, &$arr,OCI_RETURN_LOBS); > $arr["JPGIMAGE"]->load(); > ?> > <!-- <img src="??????????.???"> How can display the below jpg > field data?--> > </body> > </html> > > P.S.: The below code gives an error like... > Fatal Error: Call to a member function on a non-object in > jpg.php line XX. > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: > php-list-admin@lists.php.net >