RE: [PHP] get all except 1
| From: | Dan McCullough | Date: | Wed, 21 Jul 2004 01:33:26 +0000 |
| Subject: | RE: [PHP] get all except 1 | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-191252@lists.php.net to get a copy of this message | ||
Anything wrong with
SELECT * FROM story WHERE approved = 1 AND newsId != $newsId AND editionId =
$eid ORDER BY newsSortOrder ASC
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:holmes072000@charter.net]
Sent: Tuesday, July 20, 2004 9:29 PM
To: php-general@mccullough-net.com
Cc: php-general@lists.php.net
Subject: Re: [PHP] get all except 1
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