mysql_num_rows

[eluser]davidIgniter[/eluser]
Hi,
how I count the number of rows my query produce?
I'm keeping it in $query

thanks

[eluser]Rey Philip Regis[/eluser]
This is how you do it.

Code:

$query->num_rows()

Sample

Code:

$query = $this->db->get('users');

$number_of_rows = $query->num_rows();

echo $number_of_rows;

Good day.

[eluser]GSV Sleeper Service[/eluser]
if you're using the CI db class, then you just use $query->num_rows();

[eluser]davidIgniter[/eluser]
thanks. works