Help with SELECT criteria

[R0CKY]

I have a line of code that selects from the dbase ordered by the date of the entry, like this :

 

$result = $db->GetArray("SELECT * FROM ".$dbPrefix."files ORDER BY file_time DESC");

 

I would like to exclude from that result though when a specific field (ID) is a specific value (40)

 

So in plain English it would be "select from the dbase ordered by time, excluding all files where the ID = 40.

 

How would I alter the above code to achieve this?

 

Many thanks!

[MadnessRed]

$result = $db->GetArray("SELECT * FROM ".$dbPrefix."files WHERE `id` <> 40 ORDER BY file_time DESC");

[R0CKY]

Thank you.