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");

Ragni Munjal · Accepted Answer · 2012-12-13 04:24:19Z

8

Use num_rows() method

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

?>

answered Dec 13, 2012 at 4:24

Ragni Munjal

1428 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Michael Grigsby Over a year ago

thanks man. I couldn't seem to figure out how to do it on an active record object. i new how to do it in native php though lol

el_pup_le · Accepted Answer · 2012-12-13 04:23:10Z

0

$this->db->query("SELECT u.*, COUNT(u_all.*) FROM users u, users u_all WHERE u.itemNumber = 1");

answered Dec 13, 2012 at 4:23

el_pup_le

12.2k26 gold badges91 silver badges146 bronze badges

Comments

Supericy · Accepted Answer · 2012-12-13 04:25:12Z

0

$numRows = $this->db->query("SELECT count(*) FROM users WHERE itemNumber = 1");

answered Dec 13, 2012 at 4:25

Supericy

5,8911 gold badge23 silver badges25 bronze badges

Collectives™ on Stack Overflow

Codeigniter run mysql query and echo number of returned rows

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related