+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: mysql_num_rows (/showthread.php?tid=13781)
mysql_num_rows - El Forum - 12-05-2008
[eluser]davidIgniter[/eluser]
Hi,
how I count the number of rows my query produce?
I'm keeping it in $query
thanks
mysql_num_rows - El Forum - 12-05-2008
[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.
mysql_num_rows - El Forum - 12-05-2008
[eluser]GSV Sleeper Service[/eluser]
if you're using the CI db class, then you just use $query->num_rows();
mysql_num_rows - El Forum - 12-05-2008
[eluser]davidIgniter[/eluser]
thanks. works