Welcome Guest, Not a member yet? Register   Sign In
Simple query question
#4

[eluser]markanderson993[/eluser]
Thanks for your speedy reply.

I tried this

Code:
$second_verify = $this->CI->db->query("
                SELECT *
                FROM 'user'
                WHERE
                    'user_name' = ". $this->CI->db->escape($username_login) . " and
                    'password' = md5(concat(md5('" . $this->CI->db->escape($password_login) . "'), salt))
            ");

But now I get this error message

Quote:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''user' WHERE 'user_name' = 'anderma' and ' at line 2


Messages In This Thread
Simple query question - by El Forum - 02-17-2009, 07:16 PM
Simple query question - by El Forum - 02-17-2009, 07:37 PM
Simple query question - by El Forum - 02-17-2009, 07:39 PM
Simple query question - by El Forum - 02-17-2009, 07:40 PM
Simple query question - by El Forum - 02-17-2009, 07:43 PM
Simple query question - by El Forum - 02-17-2009, 07:45 PM
Simple query question - by El Forum - 02-17-2009, 07:48 PM
Simple query question - by El Forum - 02-17-2009, 07:50 PM
Simple query question - by El Forum - 02-17-2009, 07:56 PM
Simple query question - by El Forum - 02-17-2009, 08:00 PM
Simple query question - by El Forum - 02-17-2009, 08:01 PM
Simple query question - by El Forum - 02-17-2009, 08:11 PM



Theme © iAndrew 2016 - Forum software by © MyBB