I asked a similar question the other day, I was told to use the password function on the field name, not the value, i havent tested this and its a weird way to do things, and why cant both work? (if any)
"Mike Tsapenko" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hello, Victor. > > Your queries seem to be OK. The second one has typo: after should be single > quot. > Anyway this is a problem with MySQL but not with PHP. > > -- > ============ > Mike Tsapenko > Chief of Web-development Dept. > AlarIT > http://www.AlarIT.com > > > "Victor" <[EMAIL PROTECTED]> ???????/???????? ? ???????? ?????????: > 000101c24f92$e7e80fc0$a3a96518@jumpy">news:000101c24f92$e7e80fc0$a3a96518@jumpy... > > Is PASSWORD() still usable? I used it in my scripts a while ago to > > encrypt and decript password strings that I stored into databases, but > > from some time all my scripts don't work (the login part) because I > > cannot do a mysql query like so: > > > > $sql = "SELECT * FROM users WHERE username = '$PHP_AUTH_USER' AND > > password = PASSWORD('$PHP_AUTH_PW')"; > > > > or: > > > > $sql = "SELECT * FROM users WHERE username = '$username AND password = > > PASSWORD('$password')"; > > > > is this wrong? > > > > Or am I just hallucinating? > > > > - vic > > > > ______________________________________________________________________ > > Post your free ad now! http://personals.yahoo.ca > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
