Problem with mySQL Query
This is the query I have:
$dbqueryshipping1 = select * from tempuserpurchase where
(usersessionid=\$User_Shopping_Id\) and day=\1\ and type!=\Meal+Plans\ ;
What I want to do is to select everything from tempuserpurchase that matchs the user
session and the day, so
it's an integer, but MySQL is
forgiving.
---John Holmes...
- Original Message -
From: Phillip Blancher [EMAIL PROTECTED]
To: PHP List [EMAIL PROTECTED]
Sent: Wednesday, July 23, 2003 5:08 PM
Subject: [PHP] Problem with MySQL Query
Problem with mySQL Query
This is the query I have
Subject: [PHP] Problem with MySQL Query
Problem with mySQL Query
This is the query I have:
$dbqueryshipping1 = select * from tempuserpurchase where
(usersessionid=\$User_Shopping_Id\) and day=\1\ and
type!=\Meal+Plans\
;
What I want to do is to select everything from tempuserpurchase that
matchs
Hello,
This is a reply to an e-mail that you wrote on Wed, 23 Jul 2003 at
22:28, lines prefixed by '' were originally written by you.
As per your suggestion
$dbqueryshipping1 = select * from tempuserpurchase where
(usersessionid=$User_Shopping_Id) and day=1 and
type!='Meal
Plans'
$dbqueryshipping1 = select * from tempuserpurchase where
(usersessionid=\$User_Shopping_Id\) and day=\1\ and
type'Meal Plans'
Tryed both methods and it is still not excluding anything matching Meal
Plans
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system
$dbqueryshipping1 = select * from tempuserpurchase where
(usersessionid=\$User_Shopping_Id\) and day=\1\ and
type'Meal Plans'
Tryed both methods and it is still not excluding anything matching Meal
Plans
Been a short while since I used SQL with my PHP, but try putting NOT instead
Hello,
This is a reply to an e-mail that you wrote on Wed, 23 Jul 2003 at
22:54, lines prefixed by '' were originally written by you.
$dbqueryshipping1 = select * from tempuserpurchase
where
(usersessionid=$User_Shopping_Id) and day=1 and
type'Meal Plans'
Tryed both methods and it
Tried NOT LIKE and that didnt exclude it either.
I am trying to exclude only 'Meal Plans'
Phil
- Original Message -
From: David Nicholson [EMAIL PROTECTED]
To: Phillip Blancher [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, July 23, 2003 6:19 PM
Subject: Re: [PHP] Problem
List
Subject: Re: [PHP] Problem with MySQL Query
Tried NOT LIKE and that didnt exclude it either.
I am trying to exclude only 'Meal Plans'
Phil
- Original Message -
From: David Nicholson [EMAIL PROTECTED]
To: Phillip Blancher [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, July
9 matches
Mail list logo