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);