SELECT with WHILE NOT
| From: | Andre Dubuc | Date: | Sun, 26 Jan 2003 00:28:14 +0000 |
| Subject: | SELECT with WHILE NOT | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-133144@lists.php.net to get a copy of this message | ||
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