Re: PASSWORD()
| From: | Mike Tsapenko | Date: | Thu, 29 Aug 2002 22:05:17 +0000 |
| Subject: | Re: PASSWORD() | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-114560@lists.php.net to get a copy of this message | ||
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