previous environment:
new environment:mysql 4.0.18 (max debug)
php 4.3.1
windowsNT server
webserver - IIS
I have a varchar(40) password field that I used to store sha() encrypted passwords in. In the previous environment, I could use :mysql 4.1.9-nt-log
php 4.3.1
windows2003 server
webserver - Apache 2.0.52
Code: Select all
$password = sha1($password);
$checkUser = mysql_query ("SELECT * FROM users WHERE User = '$userid' AND PASSWORD = '$password'",$web_connection) or exit (mysql_error());In the new environment...it doesn't work & no mysql_error is output.
The only signigicant difference I can see is with the newer db version and using Collation. I changed my table from the default latin1_swedish_ci to default-character-set=utf8 in the my.ini file for future table addition. I also change the current user table (to which my query goes against) to utf8_bin (I've tried a few others as well).
Do you think that the Collation column is my problem? The php code didn't change a bit.
Thanks