selected date sums values month and day

[hkalan2007]

Hello,

 

I have a datepicker that when a date is selected, the post to a php file will get the sum values for that selected day, month, and year.

 

I have the "by day" working with this...

 

 

<?php  
$choice = (isset($_POST['choice'])) ? date("Y-m-d",strtotime($_POST['choice'])) : date("Y-m-d"); 
$con = mysql_connect("localhost","root","xxxxxxxxxx");  
if (!$con)  {  
die('Could not connect: ' . mysql_error());  
}  
mysql_select_db("inverters", $con);  
$sql = "SELECT sum(power/1000) AS choice FROM feed WHERE date = '".$choice."' group by date"; 
$res = mysql_query($sql) or die('sql='.$sql."\n".mysql_error()); 
$row = mysql_fetch_assoc($res); 
echo $row['choice'].'<br />';  
?>

 

But by month and year are not clicking...

 

Help Please

 

Alan