RE: [PHP] Problem with MySQL Query
| From: | Chris Kay | Date: | Wed, 23 Jul 2003 23:19:57 +0000 |
| Subject: | RE: [PHP] Problem with MySQL Query | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-156560@lists.php.net to get a copy of this message | ||
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: chris@eleet.com.au
-----Original Message-----
From: Phillip Blancher [mailto:phil@ontarioweb.ca]
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" <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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php