[Resolved] little simple problem

[nomad9]

Got a problem with syntax.

I can't figure out how to script this :

if($show == "others"){
$sql = "SELECT * FROM cmList WHERE cmCity NOT "'montreal'" AND "'quebec'""; 
$result = @mysql_query($sql) or die('Erreur : '.mysql_error());
}

What i want is to display all the city except for montreal and quebec

Help please

Steve

[nomad9]

ok i got it :

if($show == "others"){
$sql = "SELECT * FROM cmList WHERE cmCity NOT IN ('montreal', 'quebec')";
$result = @($sql) or die('Erreur : '.mysql_error());
}