Joomla 2.5 SELECT query result in array

[vdyl]

Code: Select all

function getCategorie()
{
    $db = JFactory::getDBO();
    
    $query = "SELECT id,title FROM #__categories ORDER BY title ASC";
    
    $db->setQuery($query);
    return $db->loadObjectList();
}

results in

Code: Select all

array(8) {
  [0]=>
  object(stdClass)#165 (2) {
    ["id"]=>
    string(1) "2"
    ["title"]=>
    string(17) "Ongecategoriseerd"
  }
  [1]=>
  object(stdClass)#195 (2) {
    ["id"]=>
    string(1) "3"
    ["title"]=>
    string(17) "Ongecategoriseerd"
  }
}

but how do I make a foreach statement of it? When i try to do a foreach I get the following error message

Fatal error: Cannot use object of type stdClass as array in

[pe7er]

Welcome to Joomla forum!

What's the variable that contains the $db->loadObjectList() object?
if it's $result, then use print_r($result) to see the complete object with all arrays.

maybe you could use something like:

Code: Select all

foreach($result as $item){
    echo $item->id." - ". $item->title."<br>";
}