Please Please Help

[oo7ml]

I am just creating my first table in mySQL through phpMyAdmin

I am unsure of the correct TYPE of certain and LENGHT VALUES for two fields

dob - date of birth ( and what is the best way to create this in a form - should i use three different combo boxes for date - month - year OR is there a better way

photo - which is a photo of a new user (this photo would be straight form a digital camera and would not be cropped to a smaller size)

thanks for your help

[chazzy]

in general, actual files (like pictures) are stored on the file system, and you store in the database where the file is located. so a varchar(255) should be enough.

any dates should be stored in the database as a date/time type.

[oo7ml]

Ok thanks but what should the Length/Values of the: dob - DATETIME - ?

Thanks for your help

[chazzy]

datetime's don't need a length.