Count function()

[Psyclasse]

I have these two table with some data sample in them. I would like to to pull out number of classifieds in each category. I gave it a try, and I got (2) in each one which is not correct. So hopefully someone will help me with this.\[code\]CREATE TABLE IF NOT EXISTS `categories` ( `id` int(255) NOT NULL AUTO_INCREMENT, `name` text COLLATE utf8_unicode_ci NOT NULL, `subcategory_id` int(2) NOT NULL DEFAULT '0', `parent_id` int(255) NOT NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=27 ;---- Dumping data for table `categories`--INSERT INTO `categories` (`id`, `name`, `subcategory_id`, `parent_id`) VALUES(1, 'Announcements', 0, 0),(2, 'Employment', 0, 0),(3, 'Items For Sale', 0, 0),(4, 'Services', 0, 0),(5, 'Garage Sales', 0, 0),(6, 'Automobiles', 0, 0),(7, 'Announcement1', 1, 1),(8, 'Announcement2', 1, 1),---- Table structure for table `classifieds`--CREATE TABLE IF NOT EXISTS `classifieds` ( `classified_id` int(255) NOT NULL AUTO_INCREMENT, `title` text COLLATE utf8_unicode_ci NOT NULL, `description` text COLLATE utf8_unicode_ci NOT NULL, `category_id` int(10) NOT NULL, `name` text COLLATE utf8_unicode_ci NOT NULL, `authorized` int(10) NOT NULL DEFAULT '0', PRIMARY KEY (`adid`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=177 ;---- Dumping data for table `classifieds`--INSERT INTO `classifieds` (`classified_id`, `title`, `description`, `category_id`, `name`, `authorized`) VALUES(1, 'Test Classified', 'Here is the First Test classified listing.', 1, 1);INSERT INTO `classifieds` (`classified_id`, `title`, `description`, `category_id`, `name`, `authorized`) VALUES(2, 'GMC For Sell', 'Looks like new 1979 GMC.', 6, 1);\[/code\]here\[code\]$query = "SELECT category_id, COUNT(title) FROM classifieds GROUP BY category_id"; $result = mysql_query($query) or die(mysql_error());$row = mysql_fetch_array($result)$num_items_in_category = $row['COUNT(title)'];echo "<><a href='http://stackoverflow.com/questions/10544628/category-".$row['id'].".php' >".$row['name'].$num_items_in_category."</a></li>";\[/code\]Thanks