Re: Num rows for postgres

To answer my own question. I needed to add this wrapper function to DB.php to get $sth->numRows() to work. /** * Get the the number of rows in a result set. * * @return int the number of rows, or a DB error code */ function numRows() { return $this->dbh->numRows($this->result); } Regards, Paul > I am using postgres and I am trying to get the number of results returned > by a select query. > > I would have hoped that something like this would work: > > $sql = "SELECT * FROM my_table"; > $sth = $dbh->query($sql); > $num_rows = $sth->numRows(); > echo $num_rows; > > No go however. Does anyone know how to get the number of rows in a result > set using the PEAR database abstraction library? > > Regards, > Paul > > > > > -- > PHP Extension and Add-on Repository (PEAR) mailing list. > Documentation can be found at http://pear.php.net/doc/pear.html > To unsubscribe, e-mail: php-pear-unsubscribe@lists.php.net from the > mail address you subscribed with. > >