July 12th, 2000, 08:54 PM
Time spent in forums:
<BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">quote:</font><HR>Originally posted by Robert_J_Sherman:
I seem to be having a bit of a difficulty,
I am try to do a match of a users form entered password.
I've been trying this:
SELECT * FROM users WHERE password=PASSWORD('$theirpassword');
naturally the $theirpassword is the users
MySQL isn't returning a match.. when I know the password is entered correctly...
any any any idea what/why?
I've solved my own problem, it appears that I just didn't set my password field (in the database) to the right length.. guess I just didn't realize that the field needed to be something like VARCHAR(50) in order for the comparrisons to work out..
Low Cost Hosting and Web Development.