MySQL update killed my login...

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 sess_id='$sess_id', 
sess_id_start='$date'
where md5(usr_name)='$usr_name' and password=PASSWORD('$password') 
",$connection))
{
header("Location: http://www.domain.net/loginscreen.php";);
exit;
}
else
{
Do Login and stuff...

This worked until today. I called the ISP and they confirmed that there was 
a database update yesterday.

-Will

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux