I was hoping to create a simple calendar. Generate count of entries by encoder daily and viewed in calendar style. Like January, February, etc.. or display entire year by month.
database have date_added and encoder columns
I have problem on putting it on one piece. I was hoping to find one. But no luck.
Like this style: http://i599.photobucket.com/albums/tt79/emcevo/calendarreportviewproject_zps1445f4c8.jpg
I got this code: but this is not I wanted:
// SIX (6) DAYS AGO
$query = "SELECT COUNT(date_added) FROM `tbl_dv` WHERE `encodedby` = '".$_SESSION['name']."' AND DATE(date_added) = CURDATE() - INTERVAL 6 DAY";
$result = mysql_query($query) or die(mysql_error());
// Print out result
while($row = mysql_fetch_array($result)){
echo "<font size='3'><b>[ ". $row['COUNT(date_added)'] ." ]</b></font> ENTRIES";
}
// FIVE (5) DAYS AGO
etc...
I want to have like the link above.. I have problem on implementing it in a true calendar format..