On Tue, October 4, 2005 12:07 pm, blackwater dev wrote:
> I am querying a MSSQL db where an jpg image is stored as a blog.
>
> I have this code:
>
> <html>
> <head>
> <meta http-equiv="Content-Type" content="image/jpg">
I don't think you can use Content-type for this purpose...
Or, at least, I wouldn't expect browsers to be reliable in doing it.
It MIGHT be just case-sensitive to Content-type...
Rip out ALL the HTML code here, and do:
> </head>
> <body>
> <?
> //Do the query
> include_once("../includes.list.php");
> $ms_sql= new ms_db();
> $my_sql=new Database();
> $query="select photo from cars where id=22";
> $data=$ms_sql->query($query);
> while($obj = $ms_sql->objects('',$data)){
header("Content-type: image/jpg");
> echo $obj->photo;
> }
> $data=$ms_sql->disconnect();
> ?>
> </body>
> </html>
>
> But when viewed I just get all the junk code:
>
> !1AQaq"2�B'¡±� #3Rðbr�
> $4á%ñ&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyzâ??Æ?â??â?¦â?
â?¡Ë?â?°Å
'""â?¢â??â??Ë?â?¢Å¡Â¢Â£Â¤Â¥Â¦Â§Â¨(c)ª²³´µ¶·¸¹ºÃ?Ã?Ã?Ã?Ã?Ã?Ã?Ã?Ã?Ã?Ã?Ã?Ã?Ã?Ã?Ã?Ã?Ã?âãäåæçèéêòóôõö÷øù
>
> What is wrong?
The browser is showing you the JPEG as "text"
If you had the actual JPEG, and you opened it in, like, Notepad or
whatever, that's what you would see.
--
Like Music?
http://l-i-e.com/artists.htm
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
