[RESOLVED] thumbnail images

[mrbill501]

Hi
Could anyone help with this bit of code for taking image blobs from a database and displaying them at a thumbnail size? I'm getting a Parse error: parse error, unexpected $ error on line 36 and cant see anything wrong with it.
Thanks.
<?php
ini_set("include_path","/home/fhlinux192/s/studentart.streamlinenettrial.co.uk/user/htdocs/includes/");
include ('pics.inc');
$connection = mysql_connect($host,$user,$password)
or die(mysql_error());
$db = mysql_select_db($database, $connection)
or die(mysql_error());
if (isset($GET['image_id'])) {
$image_id = $GET['image_id'];
// Check if ID exists
//if(!is_numeric($image_id)) or die("No image with the ID: ".$image_id);
// Get data from database
$query = "SELECT FROM tbl_images WHERE image_id = '$image_id'";
$result = mysql_query($query);
// read imagetype + -data from database
if(mysql_num_rows($result) == 1) {
$fileType = mysql_result($result, 0, "image_type");
$fileContent = mysql_result($result, 0, "image");
// get originalsize of image
$im = imagecreatefromstring($fileContent);
$width = imagesx($im);
$height = imagesy($im);
// Set thumbnail-width to 100 pixel
$imgw = 120;
// calculate thumbnail-height from given width to maintain aspect ratio
$imgh = $height / $width $imgw;
// create new image using thumbnail-size
$thumb=imagecreate($imgw,$imgh);
// copy original image to thumbnail
imagecopyresized($thumb,$im,0,0,0,0,$imgw,$imgh,imagesx($im),imagesy($im));
// show thumbnail on screen
$out = imagejpeg($thumb);
header("Content-type: $fileType");
echo $out;
};
?>

[Rodney_H_]

You have an unclosed/unmatched curly brace....

[mrbill501]

Cool thanks. I thought it might be something like that. You know how it is when you have been staring at the same code for a few hours.
I dont get any errors anymore but the code doesnt seem to work. I'm using the image syntax: <img src="getthumb.php3?image_id=336"> to view the images and all i get is a broken image box.

[mrbill501]

Right nailed it. If anyone wants to know how to make thumbnails, this is it. Create a new page called getthumb.php3 and insert this code changing where needed:
<?php
database connections and all that goes here
if (isset($GET['image_id'])) {
$image_id = $GET['image_id'];
$query = "SELECT FROM tbl_images WHERE image_id = '$image_id'";
$result = mysql_query($query);
if(mysql_num_rows($result) == 1) {
$fileType = mysql_result($result, 0, "image_type");
$fileContent = mysql_result($result, 0, "image");
$im = imagecreatefromstring($fileContent);
$width = imagesx($im);
$height = imagesy($im);
$imgw = 120;
$imgh = $height / $width $imgw;
$thumb=imagecreate($imgw,$imgh);
imagecopyresized($thumb,$im,0,0,0,0,$imgw,$imgh,imagesx($im),imagesy($im));
$out = imagejpeg($thumb);
header("Content-type: $fileType");
echo $out;
}
};
?>

image_id is the images primary key number.
image is the blob itself
image_type is the mime type.

The code to view the images is: <img src="getdata.php3?image_id=336"> where the image_id is equal to an actual image_id.
This isnt the ultimate answer but its taken me 4 days and this is the best I can come up with and if it can save anyone the frustration I've been through then its worth it.