Hello! I'm having some difficulties getting fetchOne() and fetchRow() to work. Here's my code..

$sql = "SELECT Count(*) as row_count FROM $table_name $where";
$row_count = $this->db->fetchOne($sql);

The error I get is: Fatal error: Call to undefined method DB_mysql::fetchOne()

If I change it to fetchAll(), it works just fine.

Any ideas?

Thanks!
- Bret

Nevermind! I figured it out.

$sql = "SELECT Count(*) as row_count FROM $table_name $where";

$this->db->setFetchMode(DB_FETCHMODE_ASSOC);
$row_count = $this->db->getOne($sql);