bit of help needed

Posted on 16th Feb 2014 by admin

Im about to sort out my registration page for my website by customising a "registration" script I came across. It has about all that I need, apart from the changes that i need to make to it to work for my environment. There is one little problem that is niggling me though cos i know ill come across it if i do it wrong so want a pointer on how to get around it. My registration page has all the usual entries that you normally have to make on such a page; such as username, password (md5 style), email, etc etc. The problem I think ill be facing though, what do I do about entries such as date of birth and things. The Date of Birth (ie DoB) has 3 selections to it, obviously, dd mm yyyy in that form in 3 drop down boxes. How do i interpret that in my INSERT statement. MySQL is showing the date format as yyyy-mm-dd in my database and thats how ive set it at this moment but id like to change that so it shows dd-mm-yyyy in one field in the database. BUT, how would i insert 3 seperate fields (dd, mm, yyyy) in my registration page into one field on my database. Im hazarding a guess that this may not be possible but if it is i would like to know how.

Other forums