Re: Problem with MySQL Query
| From: | David Nicholson | Date: | Wed, 23 Jul 2003 22:19:39 +0000 |
| Subject: | Re: Problem with MySQL Query | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-156554@lists.php.net to get a copy of this message | ||
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 is still not excluding anything matching
> Meal
> Plans
Is the data you are wanting to exclude exactly 'Meal Plans' (case
sensitive). If not, use:
type NOT LIKE 'Meal Plans'
David.
--
phpmachine :: The quick and easy to use service providing you with
professionally developed PHP scripts :: http://www.phpmachine.com/
Professional Web Development by David Nicholson
http://www.djnicholson.com/
QuizSender.com - How well do your friends actually know you?
http://www.quizsender.com/
(developed entirely in PHP)