Assistance needed for MVC newbie

Additionally, CI's db->query() method usually returns a result object, so you can use $result->num_rows() to get the number of rows, assuming your model's query() method is returning the result of the db->query() method.

You shouldn't call MySQL functions directly from your model, especially since the PHP mysql_* functions are deprecated (use the methods provided by CI's database library and configure it to use mysqli or pdo).

Bonfire

Practical CodeIgniter 3
CodeIgniter Testing Guide