Dan McCullough wrote:
Haven't done this in a while, but here is my question. I have 4 stories, and you land on the story page where one story is shown and on the side there is a listing of the other 3 stories that are active in that edition. So what I would like to do in one query is get the three that are not shown on that page.
So can I do something like
$story_sql="SELECT * FROM story WHERE approved = 1 AND editionId = $eid EXCEPT nid = $nid";
$nid is the id of the story whos detail page we are on
SELECT * FROM story WHERE approved = 1 AND editionID = $eid AND nid <> $nid
-- ---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
