Looping through a DB for all information

[eluser]CroNiX[/eluser]

Code:

$data = $this->db
  ->select('type, COUNT(id) AS total')
  ->group_by('type')
  ->get('toys')
  ->result_array();

foreach($data as $d)
{
  echo 'Type: ' . $d['type'] . ', Total: ' . $d['total'] . '<br>';
}