On Wed, 24 Mar 2004 20:46:33 -0500, [EMAIL PROTECTED] (Andy B) wrote: >hi... > >trying to figure out what is wrong here... the code is supposed to check an md5'd >password from a form and compare it against an md5'd password in a mysql table... for >some strange reason when i run the code below on my dev server (apache 2.0.47, >php4.3.3 and mysql 4.1-A) it works. when i run it on the live site (apache 1.0.3.2, >php 4.1.2 and mysql 3.22.5.6) it wont work and for that matter wont even return an >error!
>mysql_query("select * from rnjresort.users where username='$username' and >pwd=md5($password)"); Try to put md5($password) inside single quotes, like this mysql_query("select * from rnjresort.users where username='$username' and pwd='".md5($password)."'"); or maybe $crypted_pass = md5($password); mysql_query("select * from rnjresort.users where username='$username' and pwd='$crypted_pass'"); -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php