how to access the count(*) property?

[eluser]Phil Sturgeon[/eluser]
[quote author="sandeep nami" date="1264164839"]You can use these functions and get the result

$query = $this->db->query('SELECT count(*),country,city,zip from country_location ');
$res=$query->result_array();
echo $res[0]['count(*)'];[/quote]

What in the hell is that?

Use row_array() instead of result, and give your count an alias. Or use the proper methods count_all_results().

http://ellislab.com/codeigniter/user-gui...ecord.html

Code:

echo $this->db->count_all_results('my_table');
// Produces an integer, like 25

$this->db->like('title', 'match');
$this->db->from('my_table');
echo $this->db->count_all_results();
// Produces an integer, like 17

Alternatively if you want to return information and the count, do your normal selecting and use $query->num_rows();

Code:

$this->db->select('name, address, telephone');
$query = $this->db->get('table_name');

$row = $query->row()

$name = $row->name;
$address = $row->address;
$phone = $row->telephone;

$quantity = $query->num_rows();

Come on guys its all in the documentation.