Page 2 of 2

Posted: Wed Aug 02, 2006 7:43 pm
by RobertGonzalez
Try this and see what it does...

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());