Archive"; echo "
"; $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'); ?>