Call to a member function num_rows() on a non-object

[eluser]Zorancho[/eluser]
Try using this:

Code:

function compare($fid, $uid)
{
    $fid = (int) $fid;
    $uid = (int) $uid;
    $sql = "SELECT * FROM friends_list WHERE approved_status = 'yes' AND user_id=".$uid." AND friend_id=".$fid." OR
    (friend_id=".$uid." AND user_id=".$fid.") LIMIT 1";
    $q = $this->db->query($sql);
    if($q->num_rows() > 0)
    {
        return true;
    }
    return false;
}

It worked for me