MySQL Forums
Forum List  »  Newbie

Need help with Password function
Posted by: Marius LastName
Date: May 23, 2005 04:41PM

Hi there friends,

I am using MySQL and PHP to create a user login and registration script.
I am working from VTC PHP tutorial CD.
For some reason if I insert a record in MySQL like this:
INSERT INTO users (name, password) VALUES("marius", PASSWORD("123"));
the SQL statement execute and insert the record with the encrypted password

BUT WHEN I WANT TO VERIFY LIKE THIS:
SELECT * FROM users WHERE password = PASSWORD("123"));
the SQL statement do not retrieve any matching records.


Why this????

Options: ReplyQuote


Subject
Written By
Posted
Need help with Password function
May 23, 2005 04:41PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.