Help with Images

[berbbrown]

I have images stored in my MySQL database and I can easily extract them and display within my web page.

I am using image magic to resize them and I wanted to know if anyone could tell me how I can check the physical dimensions of the image which is extracted from the database using "Image Magic"?

I need to know the width and height so I can decide whether the image should be resized.

H E L P !!!!

Thanks in advance.

BB

[Installer]

getimagesize()

[berbbrown]

I understand about the PHP function, however it requires a filename to work. The images are stored in a database table and are extracted and stored in a variable, thus:

$sqlquery = "SELECT image FROM tblproducts WHERE id = $productid";
$dataresult = mysql_query($sqlquery);
while ($datarow = mysql_fetch_array($dataresult)) {
$productimage= $datarow['image'];
}
mysql_free_result($dataresult);

header('Content-Type: image/jpeg');
print $assessmentimage;

The above code prints the image.

Any other ideas? Thanks

[kburger]

however it requires a filename to work

Yet another reason to store images in a filesystem rather than a database.

[Installer]

I agree; it seems like you'd just have a bloated database for dubious benefit. But if you're set on the db, can't you use "identify"? What interface to IM are you using?

Else you could store the height and width in the db, or maybe even in the image name.