]
Subject: [PHP-DB] MySQL result resource
hello,
i have a new issue... :-)
i am getting:
Warning: Supplied argument is not a valid MySQL result resource in
/users/infoserv/web/register/ca/admin/catads.php on line 54
from:
?
while($row = mysql_fetch_object($obj))
{
$scobj
hello,
i have a new issue... :-)
i am getting:
Warning: Supplied argument is not a valid MySQL result resource in
/users/infoserv/web/register/ca/admin/catads.php on line 54
from:
?
while($row = mysql_fetch_object($obj))
{
$scobj = mysql_db_query($dbname,select * from
...
PHP Architect - A monthly magazine for PHP Professionals. Get your copy
today. http://www.phparch.com/
-Original Message-
From: Addison Ellis [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 29, 2003 10:02 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MySQL result resource
hello
shouldn't it be PASSWORD('madonna') ??
-Original Message-
From: Necro [mailto:[EMAIL PROTECTED]]
Sent: 11 January 2002 04:39
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] MySQL Result Resource
http://www.hotscripts.com/Detailed/4219.html --- that is the script
But I cannot use crypt
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
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
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
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
() );
$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
() );
$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
-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
[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
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
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
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
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
[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
-
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
: 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
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
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] [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
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
]]
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
On Friday 11 January 2002 10:33, 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
: Shannon Doyle [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, December 19, 2001 4:19 PM
Subject: [PHP-DB] Mysql result resource error
Hi People,
I am getting a Not a valid Mysql result resource error with the
following code, can someone take a look at this for me and see
- Original Message -
From: Shannon Doyle [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, December 19, 2001 4:19 PM
Subject: [PHP-DB] Mysql result resource error
Hi People,
I am getting a Not a valid Mysql result resource error with the
following code, can someone take
27 matches
Mail list logo