Создаем счетчик объявлений - AdsManager

<?php
$all = mysql_query("SELECT * FROM jos_adsmanager_ads");
echo "Всего объявлений <u>".mysql_num_rows($all)."</u>, ";
$today = mysql_query("SELECT * FROM jos_adsmanager_ads WHERE date_created=CURRENT_DATE");
echo "за сегодня <u>".mysql_num_rows($today)."</u>, ";
$check = mysql_query("SELECT * FROM jos_adsmanager_ads WHERE published=0");
echo "на проверке у администратора <u>".mysql_num_rows($check)."</u>";
?>

<?php
$today = mysql_query("SELECT * FROM jos_adsmanager_ads WHERE YEAR(date_created) = YEAR(CURDATE()) AND MONTH(date_created) = MONTH(CURDATE()) AND DAY(date_created) = DAY(CURDATE())");
echo "Сегодняшних объявлений: <b>".mysql_num_rows($today)."</b></br> ";

$vchera = mysql_query("SELECT * FROM jos_adsmanager_ads WHERE YEAR(date_created) = YEAR(CURDATE()) AND MONTH(date_created) = MONTH(CURDATE()) AND DAY(date_created) = DAY(CURDATE()-1)");
echo "Вчерашних объявлений: <b>".mysql_num_rows($vchera)."</b></br> ";

$month = mysql_query("SELECT * FROM jos_adsmanager_ads WHERE YEAR(date_created) = YEAR(CURDATE()) AND MONTH(date_created) = MONTH(CURDATE())");
echo "Объявлений за месяц: <b>".mysql_num_rows($month)."</b></br> ";
?>

<?php 
$all = mysql_query("SELECT * FROM jos_adsmanager_ads");
echo "Всего объявлений: <strong>".mysql_num_rows($all)."</strong><br />";
$i = 0;
while($row = Mysql_fetch_array($all))
{
   if (substr($row['date_created'], 0, 10) == date("Y-m-d"))
   {
      $i++;
   }
} 
echo "За сегодня: <strong>".$i."</strong>";
?>

$today = mysql_query("SELECT * FROM jos_adsmanager_adcat WHERE catid=".JRequest::getInt( 'catid',0 ));
	echo mysql_num_rows($today);