Selecting?

[eluser]PhilTem[/eluser]
I prefer

Code:

function is_admin($username)
{
    return $this->db
                    ->from('users')
                    ->where('username', $username)
                    ->where('is_admin', '1')
                    ->count_all_results() == 1;

}

because it's much shorter (if you compress code) and you actually don't run a real select query but more a 'SELECT COUNT(*) FROM' query. Which is a little fail safer for sql-injections since it only returns a number and no full rows.

But both queries are right. I like mine just a little more since it only counts matches and doesn't select them

Refer to CI user's guide -> database class -> active record.