[RESOLVED] Error with mysql query using password variable

[jme]

Hi guys, I'm having a bit of trouble with a registration script that I'm trying to get working. Basically after the name and password have been entered I perform the following SQL query:

SELECT user_id, user_realname
FROM plc_users
WHERE user_name = '$u'
AND user_password = PASSWORD( '$p' ) 

with $u being the username and $p being the password that were entered in the form. The problem that I am having is that the query is not giving any data as a response to it, it seems to be something to do with the password part of the query as if I drop this from it I get what I would expect.

This is the query that's used to enter data into the database as well incase it could be of any use:

INSERT INTO plc_users(
user_name,
user_realname,
user_email,
user_password,
user_reg_date
)
VALUES (
'$u', '$rn', '$e', PASSWORD( '$p' ) , NOW( )
)

Any suggestions or pointers would be greatly appreciated.

Jamie 🙂

[bubblenut]

Try this as your select

SELECT user_id, user_realname, user_password, PASSWORD(user_password), PASSWORD('$p')
FROM plc_users 
WHERE user_name = '$u'

To see what is actually happening.

[jme]

SQL query: 
SELECT user_id, user_realname, user_password, PASSWORD( user_password ) , PASSWORD( '$p' )
FROM plc_users
WHERE user_name = 'jme'

gives

user_id  user_realname  user_password  PASSWORD(user_password)  PASSWORD('$p')
1 	  jamie davies 	69b4ce3f0013 	1ff2da7c6dd1ad77 	070d304548e1f7fb

[jme]

Found the problem - password was only varchar(12) rather than varchar(16) in database :o

Jamie 😉