Re: md5() ...
| From: | Chris Shiflett | Date: | Thu, 15 Aug 2002 04:16:31 +0000 |
| Subject: | Re: md5() ... | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-112671@lists.php.net to get a copy of this message | ||
Show us the output of:
select login, password from user where login='sysdata';
My guess is that the password is not "1b1c2457d12dd976d4cfa556ac6661f6" - the md5 of "sysdata".
Chris
Reymond wrote:
I have login = "sysdata" and password = "sysdata" on md5 function How to select md5 function mysql> select COUNT(*) AS result from User where login = "sysdata" and password = md5("sysdata"); +-------+ | result | +-------+| 0 |+-------+ 1 row in set (0.00 sec) I wanna the result display "1 " like this one mysql> select COUNT(*) AS result from User where login = "sysdata"; +--------+ | result | +--------+| 1 |+--------+ 1 row in set (0.00 sec)