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:[EMAIL PROTECTED]]
Sent: Sunday, 26 January 2003 11:28 AM
To: [EMAIL PROTECTED]
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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
