Re: [PHP] MySQL update killed my login...

2006-01-03 Thread William Stokes
Thanks! -W "M" <[EMAIL PROTECTED]> kirjoitti viestissä:[EMAIL PROTECTED] > It seems the upgrade was from Mysql 4.0. PASSWORD() function changed > between 4.0 and 4.1, it uses longer hashes now. You can still use > OLD_PASSWORD() function instead. > > William Stokes wrote: >> Hello, >> >> My IS

Re: [PHP] MySQL update killed my login...

2006-01-03 Thread M
It seems the upgrade was from Mysql 4.0. PASSWORD() function changed between 4.0 and 4.1, it uses longer hashes now. You can still use OLD_PASSWORD() function instead. William Stokes wrote: Hello, My ISP updated their MySQL DB to 5.0.18 and that killed my login procedure which was OK yesterd

[PHP] MySQL update killed my login...

2006-01-03 Thread William Stokes
Hello, My ISP updated their MySQL DB to 5.0.18 and that killed my login procedure which was OK yesterday. Any ideas how to start to debug this? The login updates 2 fields in users table row where username and password macthes. This is the code: if (!$query = mysql_query("update tbl_users set