Simple query question

[eluser]TheFuzzy0ne[/eluser]
Have you considered using the active record class?

Code:

FROM `user`
                WHERE
                    `user_name` = '" . $this->CI->db->escape() . "' and
                    `password` = md5(concat(md5(" . $this->CI->db->escape($password_login) . "), salt))
            ");
$this->db->where('user_name', $username_login);
$this->db->and_where('password', );
return $this->db->get('user', 'md5(concat(md5(' . $this->db->escape($password_login) . '), salt))', FALSE);

The above code is untested

I can't see why that wouldn't work for you. But it's 2:10AM here, and my brain is working about as fast as a snail on Valium.