Hi Sean,
Before sending to the list, I had already tried your first suggestion and
ended up with only the records that I wanted excluded.
Your second suggestion with "NOT IN" works like a charm. (There wasn't much
about 'NOT' in the docs, and I must have missed the 'IN' part.)
Thanks for your help!
Regards,
Andre
On Saturday 25 January 2003 07:48 pm, Sean Malloy wrote:
> 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
