Active Record: COUNT WHERE?

[eluser]Derek Allard[/eluser]
I know this thread is a getting old, but just wanted to mention that count_all_results() has been added into the svn. You'll need to update your system/database folder (and all files) and maybe also the userguide if you want that.

$this->db->count_all_results();

Permits you to determine the number of rows in a particular Active Record query. Queries will accept Active Record restrictors such as where(), or_where(), like(), or_like(), etc. Example:

Code:

echo $this->db->count_all_results('my_table');
// Produces an integer, like 25

$this->db->like('title', 'match');
$this->db->from('my_table');
echo $this->db->count_all_results();
// Produces an integer, like 17

I'd love to have you beat it up a bit, particularly if you are using a database besides MySQL.