counting database rows

Gaia Reply #1, 19 years, 8 months ago

Hi,

How can i count the number of records in a database table?

It just gives "Resource ID #xx" instead of the actual number of records.

Thanks

$foo = $modx->db->select("COUNT(*)", "foo");

opengeek Reply #2, 19 years, 8 months ago

That function returns a MySQL result set (a resource). You need to fetch the row from the result set using

$row= $modx->db->getRow($foo);
$count= reset($row);

The row is an associative array...or even easier...

$count= $modx->db->getValue($foo);

which will directly get the value of the first column in the first row returned in a result set.

Gaia Reply #3, 19 years, 8 months ago

Ah that worked great, thanks OpenGeek.