Agree fully
Try this:
$query = "select * from category where id=$scrow->category";
$result = mysql_query($query) or die( mysql_error() );
If your query fails, and u still can't find the reason from the
information that mysql_error() give you, put a "echo $query" inbetween
to see which strin
It means your query failed... it always means your query failed for some
reason (unless you typo a variable name...). Learn to use mysql_error()
in conjunction with mysql_query(). Also, like I said before,
mysql_db_query() is depreciated, you should be using mysql_query().
---John W. Holmes...
PH
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
B
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
[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 =
PASSW
n 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 ca
='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]
>
word, 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: [PH
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
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 th
> 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
st 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 do
.
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
TED]]
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: "
rname='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]
>S
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: R
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
--
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..
>
&g
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
"andr
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,
sql_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
t;
>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 PRO
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
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 Thomps
the same data. Its like it is doing each
query three times or something.
Don't know why it is doing that.
- Shannon
> -Original Message-
> From: Jim Lucas [mailto:[EMAIL PROTECTED]]
> Sent: Friday, 21 December 2001 03:52 AM
> To: Shannon Doyle; [EMAIL PROTECTED]
>
which one was giving you the problem? the first or second mysql try. if it
was the second, try wrapping the $cattyname with single quotes like this
Minor_Category = '$cattyname'. if the $cattyname var has anything but
numbers, the statement won't work.
Jim
- Original Message -
From: "S
$sql = "select Minor_Category FROM main where Page = 'wines' order by
Minor_Category";
Op donderdag 20 december 2001 01:19, schreef Shannon Doyle:
> 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 if
27 matches
Mail list logo