MySQL update killed my login...
| From: | William Stokes | Date: | Tue, 03 Jan 2006 08:03:02 +0000 |
| Subject: | MySQL update killed my login... | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-228104@lists.php.net to get a copy of this message | ||
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