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.
