Moving images from SQL BLOB to file system

[cinq]

What would be a way to get the images stored as BLOBs in my mysql db out into a file system ?
Or for that matter, out as images.

I don't want to have to individually browse and download and save over 1000 images...

Any ideas folks ?

[Tekton]

Are you using the vBulletin attachments, or some other storing system? vB you can do in the admin panel I think.

[Andreas]

PHP Code:

$handle = fopen('/path/to/file', 'w');
fwrite($handle, $blob);
fclose($handle); 


[cinq]

@Tekton, another storing system ( not mentioning about vb attachments )

@KirbyDE, thanks!
will work with that and see how it goes