How can I save files inside mysql? is this possible?

[Sina]

Hello dear gurus,

How can I save files inside Mysql?
i.e I have a couple of files (binary) of size 6 to 8 megs.
I'd like to save these files inside mysql database and use php to allow only selected users with correct users id and password to access the files (to download the files).
So basically I have a login page,
Users login, and they can download the files.

Is this possible at all?
If you could give me a hint or a sample script, I'd appricate it.

Thank you all

 

[gheist]

as BLOB's only

 

[mmilan]

I'm only a beginner, and probably wrong, but I thought BLOB was limited to 65K?

 

[gheist]

64K might be maximum sortable part of BLOB, real maximum may be from 1M...2G - Idontknow never used them

 

[mmilan]

Aha - Just had as look into it - there are four different types of BLOB...