Hello
I want to show my statistics data, now the system only show the data which is recorded only. For example, if 07-08-09 ( visitor 10 person ). Then for 06,08,09 (visitor 0 person)
Now the system only show date which have visitor only. The date which have no visitor is not showing.
The solutions i need now is i want to show all the date no matter
have a record or not. Please advise me.
$sql = "SELECT pageid, date FROM statistics WHERE pageid='".$ID."' AND date BETWEEN '$datefrom' AND '$dateto' GROUP BY date";
$items = mysql_query($sql);
echo mysql_error();
if(mysql_num_rows($items)>0){
}
}else{
}