Why are you using NOT LIKE for? NOT LIKE is used when you are doing a part search
Try this.. $dbqueryshipping1 = "select * from tempuserpurchase where usersessionid = \"$User_Shopping_Id\" && day = \"1\" && type != \"Meal Plans\""; also from your original query you are closing off the line at day=" which could be a reason for it not completing Hope this helps -- Chris Kay (CK) Eleet Internet Services P: 0415 451 372 F: 02 4620 5076 E: [EMAIL PROTECTED] -----Original Message----- From: Phillip Blancher [mailto:[EMAIL 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" <[EMAIL PROTECTED]> To: "Phillip Blancher" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
