Entering Date Of Birth Into A Database. HELP!

[ecreative]

I need some help inserting a date of birth correctly into a database. using a submission form. I want to submit the Date Of Birth using three text forms, one for day, one for , month and one for year. This will then go into a database field formatted to only take 'DATES'. Please help me!!

  $insertSQL = sprintf("INSERT INTO members_info (members_user, members_pass, members_ip, members_added, members_email, members_fname, members_sname, members_gender) VALUES (%s, %s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($_POST['members_user'], "text"),
                       GetSQLValueString($_POST['members_pass'], "text"),
                       GetSQLValueString($_POST['members_ip'], "text"),
                       GetSQLValueString($_POST['members_added'], "text"),
                       GetSQLValueString($_POST['members_email'], "text"),
                       GetSQLValueString($_POST['members_fname'], "text"),
                       GetSQLValueString($_POST['members_sname'], "text"),
                       GetSQLValueString($_POST['members_gender'], "text"));

[Wynder]

$date = $POST['year'] . "-" . $POST['month'] . "-" . $_POST['day'];

$date now contains the DATE format that MySQL is expecting. Please note that you should do data validation to make sure the date is valid before inserting it into the database, otherwise the query will fail.

[ecreative]

I have an textbox that inputs the data as YYYY-MM-DD how do i validate that form?

[Wynder]

You probably want to find a popup calendar (like http://www.mattkruse.com/javascript/calendarpopup/) and set the form field READONLY. It's a pain validating dates. ;/