Re: authentication problem

On Fri, April 29, 2005 8:50 am, Yavuz S. Atmaca said: > $sql = "SELECT user_id > FROM tbl_auth_user > WHERE user_id = '$userId' AND > user_password = PASSWORD('$password')"; Did you use the PASSWORD function when you inserted your passwords, or are they just plain-text? SELECT * FROM tbl_auth_user; If you see 'secret' in the user_password field, you need to do: UPDATE tbl_auth_user SET user_password = PASSWORD(user_password) WHERE user_id = 1; Or whatever user_id has a clear-text user_password. That's about the only thing I can see that could be messing you up... -- Like Music? http://l-i-e.com/artists.htm