As a kind soul pointed out, I missed the string joining you need to do, so I
feel tasked with addressing this further..
Simple answer: I don't see a way to do this with a single query unless you're
using a DB with subqueries.. in which case you might be able to figure
something out, but withou
Just reorder your list of selected fields.
SELECT from WHERE
-Micah
On Sunday 06 March 2005 01:10 pm, Wendell Frohwein wrote:
> Hello all,
>
> Have a question for you, don't know how simple this is. I want the
> output that mysql sends to arranged a certain way and I don't know if it
> i
Hello all,
Have a question for you, don't know how simple this is. I want the
output that mysql sends to arranged a certain way and I don't know if it
is possible.
Here is the select statement:
SELECT cart_search.id, cart_search.year, cart_makes.thename as makename,
cart_models.thename as mod
29, 2003 10:02 PM
To: [EMAIL PROTECTED]
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:
subcategory");
$scrow = mysql_
...
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
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 subcateg
-
From: "Chris Payne" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 07, 2002 7:34 PM
Subject: [PHP-DB] MySQL Result
> Hi there everyone,
>
> I have delete working perfectly by doing the following:
>
> include("connectionstart.php&
Hi Chris
> I have delete working perfectly by doing the following:
>
> include("connectionstart.php");
>
> mysql_query ("DELETE FROM emaillist WHERE EMail = '$email'
> ");
>
> However, how do I return a true or false flag whether the row was
deleted or
> not? I basically need to know how to do a
Hi there everyone,
I have delete working perfectly by doing the following:
include("connectionstart.php");
mysql_query ("DELETE FROM emaillist WHERE EMail = '$email'
");
However, how do I return a true or false flag whether the row was deleted or
not? I basically need to know how to do a 0 or
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
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=
.
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
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 passwo
var has anything but
> numbers, the statement won't work.
>
> Jim
> - Original Message -
> From: "Shannon Doyle" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, December 19, 2001 4:19 PM
> Subject: [PHP-DB] Mysql result resou
sage -
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,
$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
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 there
is anything that stands out
Thanks,
Shannon
".$cattyname."";
$catname = "";
$sql = "select Category,Code,Description,Pack,Unit,Price from main w
36 matches
Mail list logo