RE: [PHP-DB] MySQL Result Resource

Ok, I have tried a few things now. I finally got it to echo the errors, firstly there was still a prob with MD5 values being in the apostrophes. Then next error was no db was selected. So i added a mysql_select_db statement. Now i get this: 1109 : Unknown table 'andrewd' in where clause andrewd being the username I am trying to get it to accept. Following lines are the current bit: $arg = "select password, 1 as auth from acl where username='$username' and password=MD5($username.$password)"; $result = mysql_query( $arg ) or die(mysql_errno()." : ". mysql_error() ); $row = mysql_fetch_array($result); Andrew -----Original Message----- From: Miles Thompson [mailto:milesthompson@ns.sympatico.ca] Sent: Friday, 11 January 2002 2:36 AM To: php-db@lists.php.net Subject: RE: [PHP-DB] MySQL Result Resource Break up the code. I assume you are connecting to the database with mysql_connect() or mysql_pconnect(). If not, do that. Echo your query so that you know it contains valid values. Break $row = mysql_fetch_array(mysql_db_query( DATABASE, $arg )); into $result = mysql_query( $arg ) or die(mysql_errno()." : ". mysql_error() ); $row = mysql_fetch_array($result) ) then do whatever processing you need with the array $row. Miles PS Just reply to the list, if you reply directly to me I have one more message to delete. <g> /mt At 02:10 AM 1/11/2002 +1100, Necro wrote: >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:milesthompson@ns.sympatico.ca] >Sent: Friday, 11 January 2002 2:05 AM >To: Necro; php-db@lists.php.net >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: 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 -- 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