help......please!

delfa

I´m trying to display an image from access just like I do with mysql.

It simply doesn´t work!
Can you tell me what´s wrong with that code below??
please!

<? 

$gestao = odbc_pconnect ('gestao', 'xxx', 'xxxx');

$fotos = "SELECT * FROM [P-photos] WHERE ((([P-photos].[P id])=2);";
$foto = odbc_exec($gestao,"$fotos");

header ("Content-type: image/jpeg");
echo odbc_binmode($foto,"photo");

?>

barand

I admit to never having used [man]odbc_binmode[/man] but from a look at the manual entry, it doesn't return data but sets how binary data should be returned.
Try

$fotos = "SELECT * FROM [P-photos] WHERE ((([P-photos].[P id])=2);"; 
$foto = odbc_exec($gestao,"$fotos"); 
odbc_fetch_row($foto);

header ("Content-type: image/jpeg"); 
echo odbc_result($foto,"photo");

hth

delfa

Yes i have already tried that, and it simply print a bunch of binary code
and I´m sure that is image/jpeg file type!

That´s why i tried to use odbc_binmode which doesn´t work too!

Any other solution?

barand

Are you using something like <img src=myjpg.php> or just trying to echo to the page?

delfa

For now i´m just using echo but i intend to use a file to include the image

barand

Try with 2 files

:: myjpg.php ::

$fotos = "SELECT * FROM [P-photos] WHERE ((([P-photos].[P id])=2);";  

$foto = odbc_exec($gestao,"$fotos");  

odbc_fetch_row($foto); 

header ("Content-type: image/jpeg");  

echo odbc_result($foto,"photo");

:: showjpg.html ::

<html>
<body>
<img src="myjpg.php">
</body>
</html>

delfa

Yes but i could just go to http://localhost/myjpg.php
it should print an image!

The best i can get is a bunch of binary stuff on my screen!
I´m sure i´m there is something missing in the code!
I even tried that from php.net:

http://php.planetmirror.com/manual/en/function.odbc-binmode.php

and guess what?
it doesn´t work also!

Am I missing something?