";
$sql = "SELECT count( ".$tables['postid']." ) as count , MONTH( displaydate ) as month, YEAR( displaydate ) as year FROM `".$tables['post']."` WHERE 1=1 ";
if (!isset($_SESSION['username'])) {
$sql .= " AND displaydate <= '".Date("Y-m-d")."' ";
}
$sql .= " GROUP BY MONTH( displaydate ) , YEAR( displaydate ) ORDER BY displaydate DESC LIMIT 0, 10";
$query = $db->query($sql);
foreach ($query as $row)
{
echo "
".date("F", mktime(0, 0, 0, $row['month'], 10))." ".$row['year']." (".$row['count'].")";
}
echo "
";
include('footer.php');
?>