php image resize

[trektrak]

I have this code below... I would like to resize the image after uploading from mysql... is it possible... anyone can help me on this ?

<?php
 include "file_constants.php";
 // just so we know it is broken
 error_reporting(E_ALL);
 // some basic sanity checks
 if(isset($_GET['id']) && is_numeric($_GET['id'])) {
     //connect to the db
     $link = mysql_connect("$host", "$user", "$pass")
     or die("Could not connect: " . mysql_error());

     // select our database
     mysql_select_db("$db") or die(mysql_error());

     // get the image from the db
     $sql = "SELECT image FROM archive WHERE id=" .$_GET['id'] . ";";

     // the result of the query
     $result = mysql_query("$sql") or die("Invalid query: " . mysql_error());

     // set the header for the image
     header("Content-type: image/jpeg");
     echo mysql_result($result, 0);

     // close the db link
     mysql_close($link);
 }
 else {
     echo 'Please use a real id number';
 }
?>

Thanks in advanced

[ko ko]

There are some PHP image resize libraries. Google it.

[blocblue]

I came across this class a while back and have found it to be very useful.
http://www.white-hat-web-design.co.uk/blog/resizing-images-with-php/