Longblob - Detecting

[garfx]

I have various articles stored in a databse some with images some without.

is is possible to detect whether the blob is there or not using a 'if' command

table row = imgdata

if("long blob was here") {
echo "image script";
} else {
echo "there is no image on with this article";
}

thanks gareth

[halojoy]

I have no idea
but try these links
and see what we can get about using BLOB and MySQL and thumbs and IMAGES

BLOB in MySQL database http://www.sum-it.nl/en200319.php3
MySQL offers an easy feature to store photo's, drawings and documents. MySQL supports BLOBS, binary large objects in several sizes mysql.com/.... A standard size BLOB is large enough for photos.

http://www.mysql.com/doc/en/BLOB.html

see also this article:

Blobbing Data With PHP and MySQL
By: Mitchell Harper

It is a seven (7) pages article:
http://www.devarticles.com/c/a/MySQL/Blobbing-Data-With-PHP-and-MySQL/

regars ..to you 🙂
..from halojoy