php loop help

[ctcp]

Im trying to get percents from my DB

 

<?php
$statisctis="SELECT  COUNT(user_id) FROM `liked` WHERE  ((DATE_SUB(CURDATE(),INTERVAL 1 DAY) <= date_liked) AND site_id='data->site_id')  ";
$datas = mysql_query($statisctis);
$sum_datas = mysql_result($datas, 0);

function Get_Percent($number,$total)
{
$percentage = round($number * 100 / $total);
echo $percentage;
}
// Usage
Get_Percent($sum_datas,$data->coins);
?>

 

i got the result for one day i whant get result for last 12 days how can i do that? or i need to write 12 querys?

 

 

[cyberRobot]

Have you tried changing the interval to 12?

 

<?php
//...

$statisctis="SELECT  COUNT(user_id) FROM `liked` WHERE  ((DATE_SUB(CURDATE(),INTERVAL 12 DAY) <= date_liked) AND site_id='data->site_id')  ";

//...
?>