insert of birthdate

[Anon]

Hi im making a user registry system in php and mysql. I want the user to enter his birthdate in the format dd-mm-yyyy. What i thought was the best to do is to let the user choose the different dates from a dropdown, in this way to force him to enter the date in the right format. I still want the input to be inserted in only one field in the database. Is there any1 that has written an easy function to do this??

Thanks in advance.

Tom

[Anon]

make each select box part of an array then use implode("-", $array);

[Anon]

Take a look at the date() and mktime() functions. Personally, I DETEST translating date formats around between PHP and whatever database I happen to be using.

Instead, I store all dates in the DB as an integer, and use date() and mktime() to derive/retrieve the values to save/get. This gives me a completely standard way of storing this information and complete flexibility in how I decide to display this information.

Hope this helps.

-Ben