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
