Re: 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" <me@djnicholson.com> To: "Phillip Blancher" <phil@ontarioweb.ca> Cc: <php-general@lists.php.net> Sent: Wednesday, 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 = "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) > > -- > This message has been scanned for viruses and > dangerous content by Ontario Webs MailScanner, and is > believed to be clean. > > --- 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