How can i exclude a Town from the list of Towns!!!

[npsari]

I have a retreive code

 

$q = "SELECT DISTINCT Town FROM
ads
        ORDER BY Town ASC
LIMIT 12;";

$res = @mysql_query($q);

while($r = @mysql_fetch_array($res))
{	
echo "$r['Town']}";
}

 

It echos Town names

But I dont want the Town London to show

 

How can i do that

[trq]

while($r = @mysql_fetch_array($res)) {
  if ($r['town'] != 'London';
    echo $r['Town'];
  }
}

 

Better still...

 

$q = "SELECT DISTINCT Town FROM
ads
        WHERE Town <> 'London'
        ORDER BY Town ASC
LIMIT 12;";

[npsari]

Hey, thanks

 

Dont u think php should create something better

 

like the exclude function

 

Select distinct Town from ads exclude 'London' AND 'etc..'

 

[trq]

Thats SQL, nothing to do with PHP.

[npsari]

ohh, really, well, didnt know that, sorryz