Insert date to mysql using 3 text fields

[guilherme.carvalho.9250]

Hello to everyone, im having trouble in inserting a date like "2012-12-06" into a database mysql, Im using phpmyadmin+wamp and adobe dreamweaver!I want to use 3 textfields, one for the year, other for the month and a last one for the day, but I always get an error by using this

"$field_final_date1=$field2_date.'-'.$field3_date.'-'.$field4_date;"

I created 4 variables 3 of them ($field2_date,$field3_date,$field4_date) to get the year,month and day and one ($field_final_date1) to join the other 3 to form this "2012-12-06". I can i do this? I made this code here:

<?php
include"connect_database.php";
$field2_date=$_POST['field2'];
$field3_date=$_POST['field3'];
$field4_date=$_POST['field4'];
$field_final_date1=$field2_date.'-'.$field3_date.'-'.$field4_date;
$query = sprintf("insert into despesas_casa values (NULL,'%s','%s','%s','%s','%s','%s','%s','%s')",$_POST['field1'],$_POST[$field_final_date1],$_POST['field5'],$_POST['field6'],$_POST['field7'],$_POST['field8'],$_POST['field9'],$_POST['field10']);
?>

You don't need to store your data like this. Just store the full date. You can use keywords like MONTH and YEAR to extract those values from a full date in mysql. A 'datepicker' may be a better option for retrieving a date than separate fields. However, if you envisage dates from years and years ago, a datepicker can be somewhat clumsy.

[guilherme.carvalho.9250]

Hello thankyou for replying, i will search for info about using a datepicker! Thanks

OK, there are loads out there. Some good ones include the jQueryUI datepicker and some found on this review blog: http://www.hongkiat.com/blog/useful-calendar-date-picker-scripts-for-web-developers/

[guilherme.carvalho.9250]

thanks for helping will go make some experiences with it