[PHP-DB] MySQL Result Resource
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]
RE: [PHP-DB] MySQL Result Resource
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]
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:[EMAIL PROTECTED]] Sent: Friday, 11 January 2002 2:36 AM To: [EMAIL PROTECTED] 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:[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] -- 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]
RE: [PHP-DB] MySQL Result Resource
Yep, andrewd is the username im trying to get this script to work with, its an authentication script.. The result of echo $arg is the following: select password, 1 as auth from acl where username='andrewd' and password=MD5(andrewd.madonna)1109 : Unknown table 'andrewd' in where clause Andrew -Original Message- From: Miles Thompson [mailto:[EMAIL PROTECTED]] Sent: Friday, 11 January 2002 3:08 AM To: Necro; [EMAIL PROTECTED] Subject: RE: [PHP-DB] MySQL Result Resource Can you try this puppy at the MySQL console? I'd dearly love to know where andrewd is coming from, it sounds like your username. Before executing mysql_query(), echo $arg and see what it prints. This is strange, but better than what we had - Miles Thompson At 02:54 AM 1/11/2002 +1100, Necro wrote: 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:[EMAIL PROTECTED]] Sent: Friday, 11 January 2002 2:36 AM To: [EMAIL PROTECTED] 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:[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] -- 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]
RE: [PHP-DB] MySQL Result Resource
Same error... select password, 1 as auth from acl where (username='andrewd' and password=MD5(andrewd.madonna))1109 : Unknown table 'andrewd' in where clause Andrew -Original Message- From: George Pitcher [mailto:[EMAIL PROTECTED]] Sent: Friday, 11 January 2002 3:10 AM To: Necro; [EMAIL PROTECTED] Subject: Re: [PHP-DB] MySQL Result Resource I was having something similar and solved it by wrapping the column names in parentheses: select password, 1 as auth from acl where (username='andrewd' and password=MD5(andrewd.madonna)); It might help. or eliminate something if I'm not right. George - Original Message - From: Necro [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 10, 2002 4:09 PM Subject: RE: [PHP-DB] MySQL Result Resource Yep, andrewd is the username im trying to get this script to work with, its an authentication script.. The result of echo $arg is the following: select password, 1 as auth from acl where username='andrewd' and password=MD5(andrewd.madonna)1109 : Unknown table 'andrewd' in where clause Andrew -Original Message- From: Miles Thompson [mailto:[EMAIL PROTECTED]] Sent: Friday, 11 January 2002 3:08 AM To: Necro; [EMAIL PROTECTED] Subject: RE: [PHP-DB] MySQL Result Resource Can you try this puppy at the MySQL console? I'd dearly love to know where andrewd is coming from, it sounds like your username. Before executing mysql_query(), echo $arg and see what it prints. This is strange, but better than what we had - Miles Thompson At 02:54 AM 1/11/2002 +1100, Necro wrote: 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:[EMAIL PROTECTED]] Sent: Friday, 11 January 2002 2:36 AM To: [EMAIL PROTECTED] 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:[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] -- PHP
RE: [PHP-DB] MySQL Result Resource
Parse error: parse error in d:\htdocs\infekt\packages\auth.inc on line 104 $arg = select password, 1 as auth from acl where (username='andrewd' and password=MD5(andrewd.madonna)); Nope :( -Original Message- From: Andrey Hristov [mailto:[EMAIL PROTECTED]] Sent: Friday, 11 January 2002 3:28 AM To: Necro Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] MySQL Result Resource try this : select password, 1 as auth from acl where (username='andrewd' and password=MD5(andrewd.madonna)); - Original Message - From: Necro [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 10, 2002 6:18 PM Subject: RE: [PHP-DB] MySQL Result Resource Same error... select password, 1 as auth from acl where (username='andrewd' and password=MD5(andrewd.madonna))1109 : Unknown table 'andrewd' in where clause Andrew -Original Message- From: George Pitcher [mailto:[EMAIL PROTECTED]] Sent: Friday, 11 January 2002 3:10 AM To: Necro; [EMAIL PROTECTED] Subject: Re: [PHP-DB] MySQL Result Resource I was having something similar and solved it by wrapping the column names in parentheses: select password, 1 as auth from acl where (username='andrewd' and password=MD5(andrewd.madonna)); It might help. or eliminate something if I'm not right. George - Original Message - From: Necro [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 10, 2002 4:09 PM Subject: RE: [PHP-DB] MySQL Result Resource Yep, andrewd is the username im trying to get this script to work with, its an authentication script.. The result of echo $arg is the following: select password, 1 as auth from acl where username='andrewd' and password=MD5(andrewd.madonna)1109 : Unknown table 'andrewd' in where clause Andrew -Original Message- From: Miles Thompson [mailto:[EMAIL PROTECTED]] Sent: Friday, 11 January 2002 3:08 AM To: Necro; [EMAIL PROTECTED] Subject: RE: [PHP-DB] MySQL Result Resource Can you try this puppy at the MySQL console? I'd dearly love to know where andrewd is coming from, it sounds like your username. Before executing mysql_query(), echo $arg and see what it prints. This is strange, but better than what we had - Miles Thompson At 02:54 AM 1/11/2002 +1100, Necro wrote: 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:[EMAIL PROTECTED]] Sent: Friday, 11 January 2002 2:36 AM To: [EMAIL PROTECTED] 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:[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
RE: [PHP-DB] MySQL Result Resource
Miles, You must MD5 the value outside of mysql for it to evaluate it, from the error I just got. i have tried $passhash = MD5($username.$password); $arg = select password, 1 as auth from acl where (username='andrewd' and password=($passhash)); And get the following error... select password, 1 as auth from acl where (username='andrewd' and password=(c59d088cd3d873af5239cfac1234f370))1054 : Unknown column 'c59d088cd3d873af5239cfac1234f370' in 'where clause' So at least the MD5 is now evaluated. But there is still and error in there. Andrew -Original Message- From: Miles Thompson [mailto:[EMAIL PROTECTED]] Sent: Friday, 11 January 2002 3:29 AM To: Necro; [EMAIL PROTECTED] Subject: RE: [PHP-DB] MySQL Result Resource LIGHT just came on!!! Why does ittake so long. MD5(andrew.madonna) - I think you're goint to have to do this $passhash = $username . $password and use MD5($passhash). MySQL is looking for a table andrewd with the field madonna in the way the MD5() is presently structured. Go to it - Miles At 03:09 AM 1/11/2002 +1100, Necro wrote: Yep, andrewd is the username im trying to get this script to work with, its an authentication script.. The result of echo $arg is the following: select password, 1 as auth from acl where username='andrewd' and password=MD5(andrewd.madonna)1109 : Unknown table 'andrewd' in where clause Andrew -Original Message- From: Miles Thompson [mailto:[EMAIL PROTECTED]] Sent: Friday, 11 January 2002 3:08 AM To: Necro; [EMAIL PROTECTED] Subject: RE: [PHP-DB] MySQL Result Resource Can you try this puppy at the MySQL console? I'd dearly love to know where andrewd is coming from, it sounds like your username. Before executing mysql_query(), echo $arg and see what it prints. This is strange, but better than what we had - Miles Thompson At 02:54 AM 1/11/2002 +1100, Necro wrote: 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:[EMAIL PROTECTED]] Sent: Friday, 11 January 2002 2:36 AM To: [EMAIL PROTECTED] 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:[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
RE: [PHP-DB] MySQL Result Resource
On further investigation it appears to get the correct MD5 value the correct synatx is: $passhash = MD5($username.$password); --- needs the The the error resulting from this is: select password, 1 as auth from acl where (username='andrewd' and password=(163e06103a371fd95b21b4a849bb4b91))1064 : You have an error in your SQL syntax near 'a371fd95b21b4a849bb4b91))' at line 1 Does that help give any idea at all as to what the problem is? Andrew -Original Message- From: Necro [mailto:[EMAIL PROTECTED]] Sent: Friday, 11 January 2002 3:35 AM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] MySQL Result Resource Miles, You must MD5 the value outside of mysql for it to evaluate it, from the error I just got. i have tried $passhash = MD5($username.$password); $arg = select password, 1 as auth from acl where (username='andrewd' and password=($passhash)); And get the following error... select password, 1 as auth from acl where (username='andrewd' and password=(c59d088cd3d873af5239cfac1234f370))1054 : Unknown column 'c59d088cd3d873af5239cfac1234f370' in 'where clause' So at least the MD5 is now evaluated. But there is still and error in there. Andrew -Original Message- From: Miles Thompson [mailto:[EMAIL PROTECTED]] Sent: Friday, 11 January 2002 3:29 AM To: Necro; [EMAIL PROTECTED] Subject: RE: [PHP-DB] MySQL Result Resource LIGHT just came on!!! Why does ittake so long. MD5(andrew.madonna) - I think you're goint to have to do this $passhash = $username . $password and use MD5($passhash). MySQL is looking for a table andrewd with the field madonna in the way the MD5() is presently structured. Go to it - Miles At 03:09 AM 1/11/2002 +1100, Necro wrote: Yep, andrewd is the username im trying to get this script to work with, its an authentication script.. The result of echo $arg is the following: select password, 1 as auth from acl where username='andrewd' and password=MD5(andrewd.madonna)1109 : Unknown table 'andrewd' in where clause Andrew -Original Message- From: Miles Thompson [mailto:[EMAIL PROTECTED]] Sent: Friday, 11 January 2002 3:08 AM To: Necro; [EMAIL PROTECTED] Subject: RE: [PHP-DB] MySQL Result Resource Can you try this puppy at the MySQL console? I'd dearly love to know where andrewd is coming from, it sounds like your username. Before executing mysql_query(), echo $arg and see what it prints. This is strange, but better than what we had - Miles Thompson At 02:54 AM 1/11/2002 +1100, Necro wrote: 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:[EMAIL PROTECTED]] Sent: Friday, 11 January 2002 2:36 AM To: [EMAIL PROTECTED] 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:[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
RE: [PHP-DB] MySQL Result Resource
Ok, I have tried to go to PASSWORD after none of the suggestions worked out. The current statement is: $arg = select password, 1 as auth from acl where username='$username' and password = 'PASSWORD($password)'; But the error I get now is: select password, 1 as auth from acl where username='andrewd' and password = 'PASSWORD(madonna)'Resource id #2 Any ideas? Andrew -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, 11 January 2002 8:56 AM To: Necro; [EMAIL PROTECTED] Subject: RE: [PHP-DB] MySQL Result Resource Addressed to: Necro [EMAIL PROTECTED] [EMAIL PROTECTED] ** Reply to note from Necro [EMAIL PROTECTED] Fri, 11 Jan 2002 03:41:43 +1100 select password, 1 as auth from acl where (username='andrewd' and password=(163e06103a371fd95b21b4a849bb4b91))1064 : You have an error in your SQL syntax near 'a371fd95b21b4a849bb4b91))' at line 1 Does that help give any idea at all as to what the problem is? There are no quotes around 163e06103a371fd95b21b4a849bb4b91 The error occurs where it does because '163e06103' is a valid exponential notation value for a nubmer, but having an 'a' follow it is not valid. My solution would be: $Pass = md5( whatever ); # I don't care if you hash just the password # or the username and password as long as # you do it the same way as you entered # the passwords. mysql_query( SELECT password, 1 AS auth . FROM acl . WHERE username = '$username' . AND password = '$Pass' ); But I question what you are doing returning password, so it might work as well as: mysql_query( SELECT count(*) as Authorized . FROM acl . WHERE username = '$username' . AND password = '$Pass' ); This returns 0 or 1 in a field named Authorized depending on if the password matches or not. You might also want to look at the MySQL PASSWORD() function and not mess with md5 at all. Rick Rick Widmer Internet Marketing Specialists http://www.developersdesk.com -- 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]
RE: [PHP-DB] MySQL Result Resource
Daniel, I had tried both with and without quotes. Neither work. Without quotes I get: select password, 1 as auth from acl where username='andrewd' and password = PASSWORD(madonna)1054 : Unknown column 'madonna' in 'where clause' Notice that madonna has not been crypted by the PASSWORD call either. Andrew -Original Message- From: Daniel Barton [mailto:[EMAIL PROTECTED]] Sent: Friday, 11 January 2002 2:40 PM To: Necro Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] MySQL Result Resource Andrew: Don't put quotes around your MySQL function call. i.e. PASSWORD($password) not 'PASSWORD($password)' p.s. Looking at this thread, it seems like most of the errors you're encountering have nothing to do with md5() or password(), but with syntax, like placement of quotes, or whether they are single quotes or double quotes. I would suggest experimenting with the syntax a bit, to check out what's kosher, and what's not? Check out the PHP manual's sections on 'Resource id's - I think you may find it to be very important to understanding how PHP interacts with databases. Resource ids, which are returned by quite a few function calls, are not classic variables - they need to be manipulated or interpreted before you use them. Cheers, db Necro wrote: Ok, I have tried to go to PASSWORD after none of the suggestions worked out. The current statement is: $arg = select password, 1 as auth from acl where username='$username' and password = 'PASSWORD($password)'; But the error I get now is: select password, 1 as auth from acl where username='andrewd' and password = 'PASSWORD(madonna)'Resource id #2 Any ideas? Andrew -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, 11 January 2002 8:56 AM To: Necro; [EMAIL PROTECTED] Subject: RE: [PHP-DB] MySQL Result Resource Addressed to: Necro [EMAIL PROTECTED] [EMAIL PROTECTED] ** Reply to note from Necro [EMAIL PROTECTED] Fri, 11 Jan 2002 03:41:43 +1100 select password, 1 as auth from acl where (username='andrewd' and password=(163e06103a371fd95b21b4a849bb4b91))1064 : You have an error in your SQL syntax near 'a371fd95b21b4a849bb4b91))' at line 1 Does that help give any idea at all as to what the problem is? There are no quotes around 163e06103a371fd95b21b4a849bb4b91 The error occurs where it does because '163e06103' is a valid exponential notation value for a nubmer, but having an 'a' follow it is not valid. My solution would be: $Pass = md5( whatever ); # I don't care if you hash just the password # or the username and password as long as # you do it the same way as you entered # the passwords. mysql_query( SELECT password, 1 AS auth . FROM acl . WHERE username = '$username' . AND password = '$Pass' ); But I question what you are doing returning password, so it might work as well as: mysql_query( SELECT count(*) as Authorized . FROM acl . WHERE username = '$username' . AND password = '$Pass' ); This returns 0 or 1 in a field named Authorized depending on if the password matches or not. You might also want to look at the MySQL PASSWORD() function and not mess with md5 at all. Rick Rick Widmer Internet Marketing Specialists http://www.developersdesk.com -- 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] -- -- Dan Barton Terrestrial Program Biologist Asst. Data Manager Point Reyes Bird Observatory http://www.prbo.org [EMAIL PROTECTED] [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] -- 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]
RE: [PHP-DB] MySQL Result Resource
http://www.hotscripts.com/Detailed/4219.html --- that is the script But I cannot use crypt() on a winodws system. So I tried MD5, now I try PASSWORD. Any one got any idea how to make the script work with either of those?? Andrew -Original Message- From: Necro [mailto:[EMAIL PROTECTED]] Sent: Friday, 11 January 2002 3:30 PM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] MySQL Result Resource Daniel, I had tried both with and without quotes. Neither work. Without quotes I get: select password, 1 as auth from acl where username='andrewd' and password = PASSWORD(madonna)1054 : Unknown column 'madonna' in 'where clause' Notice that madonna has not been crypted by the PASSWORD call either. Andrew -Original Message- From: Daniel Barton [mailto:[EMAIL PROTECTED]] Sent: Friday, 11 January 2002 2:40 PM To: Necro Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] MySQL Result Resource Andrew: Don't put quotes around your MySQL function call. i.e. PASSWORD($password) not 'PASSWORD($password)' p.s. Looking at this thread, it seems like most of the errors you're encountering have nothing to do with md5() or password(), but with syntax, like placement of quotes, or whether they are single quotes or double quotes. I would suggest experimenting with the syntax a bit, to check out what's kosher, and what's not? Check out the PHP manual's sections on 'Resource id's - I think you may find it to be very important to understanding how PHP interacts with databases. Resource ids, which are returned by quite a few function calls, are not classic variables - they need to be manipulated or interpreted before you use them. Cheers, db Necro wrote: Ok, I have tried to go to PASSWORD after none of the suggestions worked out. The current statement is: $arg = select password, 1 as auth from acl where username='$username' and password = 'PASSWORD($password)'; But the error I get now is: select password, 1 as auth from acl where username='andrewd' and password = 'PASSWORD(madonna)'Resource id #2 Any ideas? Andrew -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, 11 January 2002 8:56 AM To: Necro; [EMAIL PROTECTED] Subject: RE: [PHP-DB] MySQL Result Resource Addressed to: Necro [EMAIL PROTECTED] [EMAIL PROTECTED] ** Reply to note from Necro [EMAIL PROTECTED] Fri, 11 Jan 2002 03:41:43 +1100 select password, 1 as auth from acl where (username='andrewd' and password=(163e06103a371fd95b21b4a849bb4b91))1064 : You have an error in your SQL syntax near 'a371fd95b21b4a849bb4b91))' at line 1 Does that help give any idea at all as to what the problem is? There are no quotes around 163e06103a371fd95b21b4a849bb4b91 The error occurs where it does because '163e06103' is a valid exponential notation value for a nubmer, but having an 'a' follow it is not valid. My solution would be: $Pass = md5( whatever ); # I don't care if you hash just the password # or the username and password as long as # you do it the same way as you entered # the passwords. mysql_query( SELECT password, 1 AS auth . FROM acl . WHERE username = '$username' . AND password = '$Pass' ); But I question what you are doing returning password, so it might work as well as: mysql_query( SELECT count(*) as Authorized . FROM acl . WHERE username = '$username' . AND password = '$Pass' ); This returns 0 or 1 in a field named Authorized depending on if the password matches or not. You might also want to look at the MySQL PASSWORD() function and not mess with md5 at all. Rick Rick Widmer Internet Marketing Specialists http://www.developersdesk.com -- 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] -- -- Dan Barton Terrestrial Program Biologist Asst. Data Manager Point Reyes Bird Observatory http://www.prbo.org [EMAIL PROTECTED] [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] -- 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