Posted by Richard Lynch on 04/29/05 20:57

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

[Back to original message]