Hi, Using PostgreSql 7.2 + PHP I am trying to do a SELECT that will choose all records except ones that have a certain id number. I can't seem to get the syntax to work.
Here's the code: "SELECT * FROM rap WHERE NOT rsponsor = '{$_SESSION['sid']}' ORDER by rsname,rfname,rcountry,rcity DESC LIMIT 20"; What I get is all the records including those with '{$_SESSION['sid']}' . How can I accomplish an exclusion in a table-wide search? Any help or advice will be greatly appreciated. Tia, Andre -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php