Database Num_rows()?

Thanks, I knew I was probably missing something somewhere.

---

For anyone remotely interested as it appears from what I have read, that there is no Num_Rows() function in CI 4, I have thrown together a quick and dirty function you can include in your models if needed. 

Note: I did NOT include any checking if the $table param was present or not, that you can write specifically for yourself.
Also only tested this for MySQL so other Databases I cannot vouch for. 

Code:

Code:

private function NumRows($table)
{
    //SQL for Counting rows in a query
    $sql = "SELECT COUNT(*) as Count FROM ".$table;

    //Execute the query and assign the result to the $row variable
    $result = $this->db->query($sql);
    $row = $result->getRow();
       
    //Get the count from the $row variable and return the result to the caller
    return $count = $row->Count;
}

countAllResults and countAll do the same thing for you. I guess num_rows was performance killer so they removed it.

If I was using the query builder (which I am not) then these work great, but i need something that I can use working directly with old fashioned SQL.