[RESOLVED]retrieving db records that do not have a specific value.

[Albatross]

I'm trying to use an sql string to return all records that do not have a specific item in them.  Here's the code :

 

$sql = "SELECT id, charname, ban FROM $table_name WHERE approved == 'none'";[/php

In the ban field portion of the form that I use as the front end, there are options the person filling it out can use.   What I'm trying to have happen is for this string to show me any records that do not equal 'none'  (which is the default option).   Short version is that I only want to see this with something other than the word 'none'

I tried <>  and == but didn't work.  Any ideas?

~~~

Ok....in writing this I found my own error.

[code=php:0]WHERE approved <>

  should have been

WHERE ban <>

 

Reason I'm leaving this post in is in case anyone else hits the same issue.