Code: Select all
$count=mysql_query("SELECT COUNT(`mos_content`.`catid`), `mos_categories`.`name` FROM `mos_content` INNER JOIN `mos_categories` ON `mos_content`.`sectionid` = `mos_categories`.`section` GROUP BY `mos_content`.`catid`;") or die('This query has some problems: ' . mysql_error());