Codeigniter run mysql query and echo number of returned rows

Question

<?=$this->db->count_all_results('users')?>

Hi, I am stuck on something. How can run a query like the below count and echo all of the returned rows? I am currently using the above statement but I need this improvement.

<?php $aa = $this->db->query("SELECT * FROM users WHERE itemNumber = 1");

Answer 1

Use num_rows() method

<?php
 $aa = $this->db->query("SELECT * FROM users WHERE itemNumber = 1");
echo $aa->num_rows();

?>