image problem

[bastienk]

I have to take an image out of a mysql db (yeah, i know "don't!" but no choice as the app is mainly written in ASP and I am doing some post insertion processeing in php...

Basically I need to extract the image from the DB, thumbnail it, and stick it back in...I am testing the extraction part but only end showing the binary cod efor the image not the image itself...so the extract works...have set the header, but still no joy...

header("Content-type: image/jpeg");
if (($results)&&(mysql_num_rows($results)==1)){
  
  //we have the image 
  while ($row=mysql_fetch_array($results)){
    $img = $row['evidence'];
  }//end while

}//end if

echo "<p><img src='$img'></p>";

All images are jpgs, so the image type header is not the issue

any ideas?


Bastien

Cat, the other other white meat

 

[sleipnir214]

The "src" attribute of an image can't be image data -- it must be a URL. What's in the column evidence?




Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[bastienk]

the image is in the evidence column..




Bastien

Cat, the other other white meat

 

[bastienk]

got it...just changed to

print $img

from

echo "<p><img src='$img'></p>";

Bastien

Cat, the other other white meat