Problem with MySQL Query
| From: | Phillip Blancher | Date: | Wed, 23 Jul 2003 21:08:41 +0000 |
| Subject: | Problem with MySQL Query | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-156537@lists.php.net to get a copy of this message | ||
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 long as type is not "Meal Plans"
However it is not excluding "Meal Plans"
Any Suggestions.
Thanks in advance,
Phil
__________________
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.501 / Virus Database: 299 - Release Date: 7/14/2003