Thanks. Discovered some old code after writing. Boy its been awhile.
dan mccullough sr. engineer url: heathermccullough.com tf: 866.298.3991 w: 603.444.9808 ________________________________ There is no such thing as a problem, unless the servers are on fire. Sometimes great opportunity comes brilliantly disguised as bad news. -----Original Message----- From: John W. Holmes [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 20, 2004 9:39 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: [PHP] get all except 1 Dan McCullough wrote: > Anything wrong with > SELECT * FROM story WHERE approved = 1 AND newsId != $newsId AND editionId = > $eid ORDER BY newsSortOrder ASC Should be fine if I understand your question correctly. You can use != or <>; same result. -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ php|architect: The Magazine for PHP Professionals - www.phparch.com -- 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