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

[eluser]markanderson993[/eluser]
Hello there codeigniter experts! I have a small and simple question. I am entering this code

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

And I keep getting this error:

Quote:A Database Error Occurred

Error Number: 1054

Unknown column 'pianoman993' in 'where clause'

SELECT * FROM user WHERE user_name = pianoman993

I know the solution must be incredibly simple but I just can't figure it out! Does anyone have any ideas?

Any help would be greatly appreciated!
Thank you!

- Pianoman993


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