Codeigniter num rows error [duplicate]

Question

When i run this code it's working fine

  echo $str = $this->db->last_query();

After this line

 if($selectRecords->num_rows()>0){
 //some action
}

I'm Gating this error

<br />
<b>Fatal error</b>:  Call to undefined method CI_DB_mysql_driver::num_rows() in <b>/vagrant/application/controllers/applicationtable.php</b> on line <b>1240</b><br />

This is my code

<?php
    public function xyz(){
            $selectRecords=$this->db->select(" (SELECT name FROM $this->reportTable WHERE id=$this->reportType) AS `$this->reportLabel`, 
                        SUM(rashi_given) AS `total` ,
                        SUM(rashi_accepted) AS atotal");
              $selectRecords->join('type', 'applicants.type=type.id', 'left');
              $selectRecords->group_by($this->reportType); 
              $selectRecords->get('applicants');
             echo $str = $this->db->last_query(); 
          if($selectRecords->num_rows()>0){

           }
     }


    ?>

What's the problem please help

Community · Accepted Answer · 2017-05-23 11:44:25Z

2

You're checking the wrong variable. See Call to undefined method CI_DB_mysql_driver::num_rows()

$rs = $selectRecords->get('applicants');
echo $str = $this->db->last_query(); 

if($rs->num_rows()>0){

}

edited May 23, 2017 at 11:44

CommunityBot

11 silver badge

answered Sep 25, 2015 at 15:05

FuzzyTree

32.4k3 gold badges58 silver badges87 bronze badges

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

Collectives™ on Stack Overflow

Codeigniter num rows error [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related