RE: [PHP] md5() ...
| From: | Reymond | Date: | Thu, 15 Aug 2002 04:37:16 +0000 |
| Subject: | RE: [PHP] md5() ... | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-112674@lists.php.net to get a copy of this message | ||
This is output...
select login, password from User where login = 'sysdata';
+---------+----------------------+
| login | password |
+---------+----------------------+
| sysdata | 1b1c2457d12dd976d4cf |
+---------+----------------------+
1 row in set (0.00 sec)
Cause I just password's field int(20) ..??
-----Original Message-----
From: Chris Shiflett [mailto:shiflett@php.net]
Sent: Thursday, August 15, 2002 11:17 AM
To: Reymond
Cc: php-general@lists.php.net
Subject: Re: [PHP] md5() ...
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)
>