[PHP] Problem with MySQL Query

2003-07-23 Thread Phillip Blancher
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

Re: [PHP] Problem with MySQL Query

2003-07-23 Thread CPT John W. Holmes
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

Re: [PHP] Problem with MySQL Query

2003-07-23 Thread Phillip Blancher
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

Re: [PHP] Problem with MySQL Query

2003-07-23 Thread David Nicholson
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'

Re: [PHP] Problem with MySQL Query

2003-07-23 Thread Phillip Blancher
$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

Re: [PHP] Problem with MySQL Query

2003-07-23 Thread Liam Gibbs
$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

Re: [PHP] Problem with MySQL Query

2003-07-23 Thread David Nicholson
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

Re: [PHP] Problem with MySQL Query

2003-07-23 Thread Phillip Blancher
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

RE: [PHP] Problem with MySQL Query

2003-07-23 Thread Chris Kay
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