Re: MySQL Result Resource
| From: | Miles Thompson | Date: | Thu, 10 Jan 2002 15:05:15 +0000 |
| Subject: | Re: MySQL Result Resource | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-15610@lists.php.net to get a copy of this message | ||
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: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net