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

Reply via email to