drop down date don't connect to database

[beginnerprogrammer]

hello there.. i have a problem with my php coding where i want to keep date choose by user in the database.

 

 

this is the drop down date

<select name="Date_Day">
<option> - Day - </option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
</select>
<select name="Date_Month">
<option> - Month - </option>
<option value="01">January</option>
<option value="02">Febuary</option>
<option value="03">March</option>
<option value="04">April</option>
<option value="05">May</option>
<option value="06">June</option>
<option value="07">July</option>
<option value="08">August</option>
<option value="09">September</option>
<option value="10">October</option>
<option value="11">November</option>
<option value="12">December</option>
</select>
<select name="Date_Year">
<option> - Year - </option>
    <option value="2010">2010</option>
<option value="2011">2011</option>
<option value="2012">2012</option>
<option value="2013">2013</option>
<option value="2014">2014</option>
<option value="2015">2015</option>
<option value="2016">2016</option>
<option value="2017">2017</option>
<option value="2018">2018</option>
<option value="2019">2019</option>
<option value="2020">2020</option>
    <option value="2021">2021</option>
<option value="2022">2022</option>
<option value="2023">2023</option>
    <option value="2024">2024</option>
<option value="2025">2025</option>
<option value="2026">2026</option>	
</select>
     

 

the code to connect to the database

      $date_year= ($_POST['Date_Year']);
	$date_month=($_POST['Date_Month']);
	$date_day=($_POST['Date_Day']);
                $date=$date_year."-".$date_month."-".$date_day;

$query="INSERT INTO aduan (date) 
			VALUES ('date($date)')";
			$result=mysql_query($query);
				 if($result){
					echo 'Registration success.';
					?><script>window.location ='thanks.php'</script>
					<?php
					}
				else
					echo 'Registration failed';}

 

when enter a value of date, the database will just show '0000-00-00'.. really hope for your help.. 

[beginnerprogrammer]

sorry but i have get the answer. i just have to change VALUES ('date($date)')"; to VALUES (date('$date'))"; . 

[Pikachu2000]

You shouldn't need to use the DATE() function at all, since the data is already formatted as a date YYYY-MM-DD. You should however, be validating/casting the incoming form values to make sure they're safe for use in the query. Right now, the query is wide open to SQL injection.