Re: mysql_query problem (more suggestions)

Hi again, Just a long shot: since password() encrypts the password that's passed through it, how did the original password get in to db anyway? Was it encrypted too? Cause if the password in the db is plain text and the user submits a plain text in a form called $password, the password() function WILL encrypt the form input and there will be no matches. try removing the password() function in the sql query and substitute it for $password only. If there is a match, then we know we need to put in the db an INSERT statement with password().. @lvin At 01:57 PM 7/17/01, Brad Wright wrote:

Jason, I have tried what yoiu suggested. result is the same. From: Jason Murray <Jason.Murray@melbourneit.com.au> Date: Tue, 17 Jul 2001 15:28:11 +1000 To: "'Brad Wright'" <bradwright@optushome.com.au>, Alvin Tan <alvintan@inscribe.com.my>, PHP General List <php-general@lists.php.net> Subject: RE: [PHP] mysql_query problem (more suggestions)

Unless i have actually defined a function 'password()', calling 'echo password('$password') will (...does, i just double checked) causes a Fatal Error 'Undefined Function'. Nice try tho :)

the original mail said to echo $query, which will include some text in it that says "password('ifovhfoiuf')" ... you should then paste that entire query into your MySQL interpreter and see what the reaction is instead of trying to secondguess it :) Jason -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net