Re: [PHP] SELECT with WHILE NOT

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

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:[EMAIL PROTECTED]]