You are here: MySQL update killed my login... « PHP « IT news, forums, messages
MySQL update killed my login...

Posted by "William Stokes" on 01/03/06 10:03

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

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация