FORUM with upload of fotos

I programmed a forum on basis mysql/php. Next aim is that the forum user can
upload fotos (*.jpg). These fotos may have descriptions. User text and fotos
may give a normal new forum contribution. As a beginning it may be
sufficient that one contribution contains one single foto.
I would like to use simple scripts which I can optimize by myself. Moreover
I would need informations about what datafield I need just to configurate my
mysql table for the fotos. Or is it necessary to store all the fotos as
jpg-files?

Thank you very much for your support.

Udo Pecher out of HOF (Germany)

"Udo Pecher" <bahncompany@t-online.de> wrote in message
news:cbm3kf$k76$00$1@news.t-online.com...
> I programmed a forum on basis mysql/php. Next aim is that the forum user
can
> upload fotos (*.jpg). These fotos may have descriptions. User text and
fotos
> may give a normal new forum contribution. As a beginning it may be
> sufficient that one contribution contains one single foto.
> I would like to use simple scripts which I can optimize by myself.
Moreover
> I would need informations about what datafield I need just to configurate
my
> mysql table for the fotos. Or is it necessary to store all the fotos as
> jpg-files?
>
> Thank you very much for your support.
>
> Udo Pecher out of HOF (Germany)

What you want to store is binary objects - look up the BLOB data type if
that's the way you want to go. Me, I store them as files so I can reach them
without using the web scripts, but whatever floats your boat. There may be
performance or security issues with either method, have a play.

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

Garp