Authenticating a User through Login

[eluser]dalebotha[/eluser]
Hi

I'm a relative new comer to CI and Php in general but my database queries have gone something like this:

Code:

function get_password($username) {
    
    $this->db->where('username', $username);

    $validate = $this->db->get('users', 1); // 'users' - table, 1 - limit

    if ( $validate->num_rows() == 1 )
    {
     return $validate->row_array();
    }
    else
    {
     return false;
    }

}

I'm too unfamiliar with CI check the rest of your code and whether your database interaction is syntactically correct but this is how I've been doing my db stuff.

I hope this helps.

Dale