IL PROTECTED]
Sent: Thursday, 24 July 2003 8:24 AM
To: David Nicholson
Cc: PHP 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" <
dnesday, July 23, 2003 6:19 PM
Subject: Re: [PHP] Problem with MySQL Query
> 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 = "s
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 me
> > $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 pu
>
> $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
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
> Plan
gt; 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
>
>
27;";
You don't need quotes around '1' since 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 2
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 da
9 matches
Mail list logo
