Yeh, I notice now the MD5 was wrong.

But I still get the same error on line 104. If I try and replace it with the
current query function then I get two errors.

e.g.
Warning: Supplied argument is not a valid MySQL-Link resource in
d:\htdocs\infekt\packages\auth.inc on line 104

Warning: Supplied argument is not a valid MySQL result resource in
d:\htdocs\infekt\packages\auth.inc on line 104

Andrew


-----Original Message-----
From: Miles Thompson [mailto:[EMAIL PROTECTED]]
Sent: Friday, 11 January 2002 2:05 AM
To: Necro; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] MySQL Result Resource



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]

Reply via email to