I have this script....
if($id) {
// you may have to modify login information for your database server:
@MYSQL_CONNECT("xxxx","xxxx","xxxx");
@mysql_select_db("xxxx");
$query = "select bin_data,filetype from binary_data where id=$id";
$result = @MYSQL_QUERY($query);
$data = @MYSQL_RESULT($result,0,"bin_data");
$type = @MYSQL_RESULT($result,0,"filetype");
Header( "Content-type: $type");
echo $data;
};
?>
This scripted is being referenced with ...
<img width='200' height='200' src='getdata.php3?id=<?=$id?>'>
As you can see I can limit the size of the picture output right here, but I need to reduce the size in KB for thumbnails which i can then link to full pictures.
I can't even seem to get the pictures out, with reduced KB.
I have tried the following suggestion with no luck...
http://groups.google.com/groups?q=PHP++thumbnail+FROM+MySQL+image&hl=en&lr=&ie=UTF-8&oe=UTF-8&selm=00a301c10b2a%24192baff0%24f6a396c0%40bigbell&rnum=9
Help Very Appreciated.
Rab
