Joining Blobs?

[seanlim]

Hi all.

 

i am storing files into a mysql database with a php script. i know its not the best method but it'll do for now.

 

the php script breaks up the file into 512kb chunks for inserting into the database. i use several UPDATE queries to add to the blob field. however, the files are always corrupted when i join them back together.

 

i think its because of the way i update the field. i use the MySQL CONCAT function now.

 

any help here? i need it urgently..

 

thanks!!

[fenway]

I usually just stream the binary data out -- check out [a href=\"http://php.dreamwerx.net/forums/viewtopic.php?t=6\" target=\"_blank\"]this excellent tutorial[/a].