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)
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
