The use of the MD5 function in the query doesn't look quite right. Shouldn't it be MD5('$password') or MD5('$username'.'$password') if concatenating?
Also, mysql_db_query() has been a deprecated function for some time now, mysql_query() is recommended. Hope this gets you going - Miles Thompson At 01:33 AM 1/11/2002 +1100, Necro wrote: >Lo all, > >Slight problem on an auth script... > > >Warning: Supplied argument is not a valid MySQL result resource in >d:\htdocs\infekt\packages\auth.inc on line 104 > > >Line 26: define( "DATABASE", "imanager" ); >Line 103: $arg = "select password, 1 as auth from acl where >username='$username' and password=MD5('$username','$password')"; >Line 104: $row = mysql_fetch_array(mysql_db_query( DATABASE, $arg )); > > >Can anyone help get this to work?? > >Thankyou. > >Andrew > > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]