Best way to count rows? about fluentpdo HOT 4 CLOSED

try $fpdo->from('table')->rowCount()

from fluentpdo.

I get an error:
Undefined index: ROW COUNT in FluentPDO/BaseQuery.php on line 76

$query = $fpdo->from('wn_test')->rowCount();
print_r($query);

Are you sure? And I think "rowCount" in PDO is slower than "SELECT COUNT(id) FROM table"?

from fluentpdo.

sorry try this $fpdo->from('table')->getResult()->rowCount() however may be your first is quicker. Countable interface is not implemented yet.

from fluentpdo.

Thanks! Now I know what to do.
Hope you can continue coding this.

from fluentpdo.