ODBC and image files

hamer7

HEY ALL-
I am trying to display an image that is stored in an access database as an OLE object onto a web page. But when I run my code i only see binary on the site... can someone look at this code and help me out.

<html>
<head>
</head>
<body>
<?php Header ("Content-type: image/gif");
$user="";
$pass="";
$DSN="cs345s04";
import_request_variables('p','p_');
$connect = odbc_connect($DSN,$user,$pass);

$query = "SELECT InsertP2 FROM Pics WHERE (CDDBNumber = 1)";

$res1 = odbc_exec($connect, $query);

$row = odbc_fetch_row($res1);
$ans = odbc_result($res1,1);

print $ans;

odbc_close($connect);
?>
<img src="searchresult.php?$ans">
</body>
</html>

theeper

AFAIK, you cannot have any output before the header() function here. Put the script into a file and include it into the HTML instead of inlining it.

Also in your link at the bottom, I am not sure what you are doing there, but that won't work, as the PHP variable will not be parsed.

should be

maybe ?

Are you using mod_rewrite here, or you just forgot the variable name?