add('POSTS', $cntposts3['COUNT(*)']); $cntpending = "SELECT COUNT(*) FROM pending"; $cntpending2 = mysql_query($cntpending); $cntpending3 = mysql_fetch_array($cntpending2); $template->add('PENDING', $cntpending3['COUNT(*)']); $cntdrafts = "SELECT COUNT(*) FROM drafts"; $cntdrafts2 = mysql_query($cntdrafts); $cntdrafts3 = mysql_fetch_array($cntdrafts2); $template->add('DRAFTS', $cntdrafts3['COUNT(*)']); $cntcomments = "SELECT COUNT(*) FROM moderation"; $cntcomments2 = mysql_query($cntcomments); $cntcomments3 = mysql_fetch_array($cntcomments2); $template->add('COMMENTS', $cntcomments3['COUNT(*)']); $cntpolls = "SELECT COUNT(*) FROM polloftheweek"; $cntpolls2 = mysql_query($cntpolls); $cntpolls3 = mysql_fetch_array($cntpolls2); $template->add('POLLS', $cntpolls3['COUNT(*)']); $cntquotes = "SELECT COUNT(*) FROM rash_quotes"; $cntquotes2 = mysql_query($cntquotes); $cntquotes3 = mysql_fetch_array($cntquotes2); $template->add('QUOTES', $cntquotes3['COUNT(*)']); $cntflagged = "SELECT COUNT(*) FROM rash_quotes WHERE flag = 1"; $cntflagged2 = mysql_query($cntflagged); $cntflagged3 = mysql_fetch_array($cntflagged2); $template->add('FLAGGED', $cntflagged3['COUNT(*)']); $cntmodcom = "SELECT COUNT(*) FROM rash_queue"; $cntmodcom2 = mysql_query($cntmodcom); $cntmodcom3 = mysql_fetch_array($cntmodcom2); $template->add('MODCOM', $cntmodcom3['COUNT(*)']); $template->display(); ?>