The query is false, because if you loook what an OR do this give :

false OR false => false
true OR false => true
false OR true => true
true OR true => true

So when your request find Argentina It is false, but when it looks the next statement 
and check if country is different of Mexico this is true, so following the OR table, 
the statement is true, so it is printed.

I think you can fix this by using a NOT stament and inverting your WHERE parameters.

and changes your request to 

SELECT country
FROM reech_leed_tool
WHERE NOT(country = 'Argentina' OR country = 'Mexico' ....)

So if we got one of the country you did not want to be printed the statement within 
the NOT is true, so by inverting it it become false and so not printed; and if the 
country of the line that is checked did not have a country WITHIN the condition.

That should fix your problem, even if I'm quite sure there is a better way.


Aurelien Vandoorine

-----Message d'origine-----
De : Hutchins, Richard [mailto:[EMAIL PROTECTED]
Envoyé : mardi 20 juillet 2004 14:20
Objet : RE: [PHP-DB] MySQL '!=' ???


Instead of using != in your statement, try using <>. I looked in my copy of
the MySQL Manual and it shows both != and <> for the not equal concept, but
the examples given only show the <> format used.

Not sure if it'll solve the problem, but it's the first thing I'd try.


> -----Original Message-----
> Sent: Tuesday, July 20, 2004 4:58 AM
> Subject: [PHP-DB] MySQL '!=' ???
> Hi there...
> I'm trying to select all records from a MySQL database, and 
> exclude those 
> from certain countries...
> I've posted a copy of an SQL statement I've got that I'm using in 
> And as you can see, I've said not to pick Argentina, but 
> there it is???
> What first year mistake am I making?
> See image below:
> http://www.risk.sungard.com/sql.gif
> Tris...
> *********************************************************************
> The information contained in this e-mail message is intended only for 
> the personal and confidential use of the recipient(s) named above.  
> If the reader of this message is not the intended recipient 
> or an agent
> responsible for delivering it to the intended recipient, you 
> are hereby 
> notified that you have received this document in error and that any
> review, dissemination, distribution, or copying of this message is 
> strictly prohibited. If you have received this communication 
> in error, 
> please notify us immediately by e-mail, and delete the 
> original message.
> **************************************************************
> *********
> -- 
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


Ce message et toutes les pieces jointes (ci-apres le "message") 
sont confidentiels et etablis a l'intention exclusive de ses destinataires.
Toute utilisation ou diffusion non autorisee est interdite. 
Tout message electronique est susceptible d'alteration. 
La SOCIETE GENERALE et ses filiales declinent toute responsabilite
au titre de ce message s'il a ete altere, deforme ou falsifie.

This message and any attachments (the "message") are confidential
and intended solely for the addressees.
Any unauthorized use or dissemination is prohibited. 
E-mails are susceptible to alteration.   
Neither SOCIETE GENERALE nor any of its subsidiaries or affiliates
shall be liable for the message if altered, changed or falsified. 


PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to