I wrote a simple SQL statement that counts the number of category IDs in a table. Problem is, its returning NULL
.
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select($db->quoteName(array('category_id','COUNT(*)')));
$query->from($db->quoteName('#__eb_event_categories'))
->group($db->quoteName('category_id'));
$db->setQuery($query);
$results = $db->loadObjectList();
var_dump($results);
When I remove COUNT(*)
the select statement is working normally. What did I write incorrectly?