[PHP] Re: JPG Images from database to filename.jpg

[Mike Gifford]

Sorry, couple post-Post changes..

The initial query should have been:
     $sql = "SELECT Image,Width,Height FROM Images WHERE ID='$ID'";

The an echo of the UPDATE sql now looks like this:

UPDATE Images SET Thumbnail='
Warning: Supplied argument is not a valid Image resource in 
/home/mike/wtoaction/public_html/caravan2001/edit_image_handler.php on 
line 34
����\0JFIF\0

\0\0
\0
\0\0��\0 Warning: Supplied argument is not a valid Image 
resource in 
/home/mike/wtoaction/public_html/caravan2001/edit_image_handler.php on 
line 40
' WHERE ID=95ReThumbnailing Successful



This is the essential part of the script which is displaying the data now:

$sql = "SELECT Format,Image FROM Images WHERE ID=$ID";
$res = dbi_query ( $sql );
if ( $res )
{
   if( $row = dbi_fetch_row ( $res ) )
   {
     Header("Content-type: image/jpeg");
     echo $row[1];
   }
   dbi_free_result ( $res );
}

The image looks just fine here:
http://www.wtoaction.org/caravan2001/image.php?ID=95

I must be missing something really simple..

Mike


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]