[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.