Hello.
>an asteriks (*) is posted with the encrypted password to the password field While solving this issue you might want to check what queries MySQL is receiving from you PHP application. See: http://dev.mysql.com/doc/refman/5.0/en/Query_log.html "W Roothman" <[EMAIL PROTECTED]> wrote: >Dear All, >When I register a new user in my (php4.1 & MySQL 4) application, using: > >$insertSQL = "INSERT INTO tblusers (uname, usurname, uusername, upassword) >VALUES ('$name', '$surname', '$username', password('$password'))"; > >an asteriks (*) is posted with the encrypted password to the password field >of the table in the DB. The password field then displays it as >*667F407DE7C6AD0 and not as 667F407DE7C6AD0. This only happens when using >Apache server on my local machine but not when using ISS. > >This causes validation to fail when using: > >$sql = "SELECT uusername FROM tblusers WHERE uusername = '$_POST[username] >AND upassword = password('$password')'"; > >but validates if I remove 'AND upassword = password('$password')'. > >Thank you for your time. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
