excluding records in a query

[jeff5656]

When I run this query to exclude records where id = $userarray['id'],

 

$q = "SELECT * FROM users WHERE inst_id = '". $userarray['inst_id'] ."' AND id != '". $userarray['id'] ."' ";

 

 

it actually ONLY returns records with $userarray['id']  as opposed to excluding them.  Isn't the way to exclude them to use != ?

[linus72982]

I believe you have to use "NOT" instead of != within an sql query.

[linus72982]

Actually, I just read up on it and learned that != is viable in a query, so, nvm.

[marcus]

$sql = "SELECT * FROM `users` WHERE `inst_id`='".$userarray['inst_id']."' AND `id`<> '".$userarray['id']."'";