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