Insert date from php in mysql?

please give me right solution. I want to insert date in mysql. mysql php form is like day month year, the three fields are stored in single dob field. In the dob field cannot be stored mysql database. Further, my mysql database dob field under the datatype is 'date' and mentioned not null. But, i... show more please give me right solution.
I want to insert date in mysql.
mysql php form is like day month year, the three fields are stored in single dob field.
In the dob field cannot be stored mysql database.
Further, my mysql database dob field under the datatype is 'date' and mentioned not null.
But, i cannot stored dob field. when arise the problem the error message is "Could not execute mysql query!Incorrect date value: '1947-August-15' for column 'dob' at row 1"
What i do? Please give me a solution.
2 answers