More than one exclusion from the SELECT statement

[crmamx]

I cannot find the right combination to include more than one exclusion from the SELECT, that is more than one WHERE !=.

 

$result = mysql_query("SELECT * FROM members WHERE last !='neville' Order By last") or die(mysql_error());  

if (!$result) {
    die("Query to show fields from table failed");
}

[AbraCadaver]

AND?

 

SELECT * FROM members WHERE last !='neville' AND last != 'chamberlain' ORDER BY last

[gristoi]

You need to use AND or OR in your statement.

Example:

SELECT a, b WHERE a !='b' AND b!= something 

[crmamx]

Many thanks. I was trying to find an operand like & or something.