Using <> in query

[jakebur01]

What is the correct way to do this?

SELECT DISTINCT CLASS FROM ARINVT01 WHERE (`CLASS` <> `AD ALLOWANCE`, `CLASS` <> 'STOP CHARGE', `CLASS` <> 'MISCELLANEOUS') ORDER BY CLASS ASC

[Pikachu2000]

The commas in the WHERE clause should be ANDs and/or ORs.

[jakebur01]

I tried it with AND and OR and I get this error for both: 

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource

 

 

SELECT DISTINCT CLASS FROM ARINVT01 WHERE `CLASS` <> `AD ALLOWANCE` AND `CLASS` <> 'STOP CHARGE' AND `CLASS` <> 'MISCELLANEOUS' ORDER BY CLASS ASC

 

 

 

[Pikachu2000]

Then you need to echo the query, along with mysql_error() if the query fails.

$query = "SELECT whatever FROM table";
if( !$result = mysql_query($query) ) {
     echo "<br>Query: $query<br>Failed with error: " . mysql_error() . '<br>';
} else {
     // continue with processing the query result
}

[jakebur01]

SELECT DISTINCT CLASS FROM ARINVT01 WHERE `CLASS` <> `AD ALLOWANCE` AND `CLASS` <> 'STOP CHARGE' AND `CLASS` <> 'MISCELLANEOUS' ORDER BY CLASS ASC

[Pikachu2000]

What was the error that was returned?

[jakebur01]

Failed with error: Unknown column 'AD ALLOWANCE' in 'where clause'

[jakebur01]

It was the quotations. Thanks.