RE: [PHP] SELECT with WHILE NOT

SELECT * FROM rap WHERE rsponsor != '{$_SESSION['sid']}' ORDER by rsname,rfname,rcountry,rcity DESC LIMIT 20 SELECT * FROM rap WHERE rsponsor NOT IN ('{$_SESSION['sid']}') ORDER by rsname,rfname,rcountry,rcity DESC LIMIT 20 -----Original Message----- From: Andre Dubuc [mailto:aajdubuc@webhart.net] Sent: Sunday, 26 January 2003 11:28 AM To: php-general@lists.php.net Subject: [PHP] SELECT with WHILE NOT 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