Re: PASSWORD()

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" <mike@alarit.com> wrote in message news:20020829220523.59122.qmail@pb1.pair.com... > 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" <victor@argilent.com> ???????/???????? ? ???????? ?????????: > 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 > >