wordpress query num_rows won't return value

Question

I try to get number of rows per query in my wordpress Class but I get each time null, what is wrong with the following

class MyClass{

    private $wpdb;
    private $query;   


     public function __construct(){
          global $wpdb;
          this->wpdb = &$wpdb;

        }

        public function build_query(){
             //dynamic query will be build here, example
            $this->query = 'SELECT id,name From my_table';
       }

        public function get_display_result(){
            $res = $this->wpdb->get_results($this->query, ARRAY_A);
            return $res;
          }

        public function get_total_results(){
            $res = $this->wpdb->get_results($this->query);
            $nr = $res->num_rows;
            var_dump($nr);// I get NULL
            exit();
            return $res;

        }

    }

`this->wpdb = &$wpdb;` where is the `$` ? – revo Jun 01 '14 at 11:37 — revo, Jun 01 '14 at 11:37
look the queries are working just not the num_rows – fefe Jun 02 '14 at 06:03 — fefe, Jun 02 '14 at 06:03

score 0 · Accepted Answer · answered Jun 02 '14 at 12:02

0

You have to use $wpdb to get number of rows

$this->wpdb->num_rows;

answered Jun 02 '14 at 12:02

nikunj gandhi

779
5
6

wordpress query num_rows won't return value

1 Answers1