return number of rows

[eluser]john_j[/eluser]
what it returns is correct, it has to return '1' because there is only one row.

Do something like this to get the count:

Code:

$result = $this->db->query('select count(*) as total_count from some_table');
if ($result != false)
{
   $my_count = $result->row();
   echo 'Total Count = '.$my_count->total_count;
}