END; $year = (empty($_GET['year']))?date('Y'):$_GET['year']; $month = (empty($_GET['month']))?date('m'):$_GET['month']; $query = dbQuery("SELECT FROM_unixTIME(date,'%e') as `day`,count(*) as `count` FROM `".$GLOBALS['prefix']."article`,`".$GLOBALS['prefix']."article_class` WHERE FROM_unixTIME(date,'%Y/%m') = '".$year."/".$month."' AND `status` = 'published' AND ".$GLOBALS['prefix']."article.class_id = ".$GLOBALS['prefix']."article_class.id AND `in_main_page` = 1 GROUP BY `day`;"); for ($i = 0;$i < mysql_num_rows($query);$i++) { $row = dbArray($query); $calendar[$row['day']] = $row['count']; }