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:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 11:17 AM To: Reymond Cc: [EMAIL PROTECTED] 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) > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
