Tris, 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. Rich > -----Original Message----- > From: Tristan.Pretty@xxxxxxxxxxxxxxxx > [mailto:Tristan.Pretty@xxxxxxxxxxxxxxxx] > Sent: Tuesday, July 20, 2004 4:58 AM > To: php-db@xxxxxxxxxxxxx > Subject: 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 > PHPMyADMIN. > 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
