[PHP] get all except 1

2004-07-20 Thread Dan McCullough
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

Re: [PHP] get all except 1

2004-07-20 Thread John W. Holmes
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

RE: [PHP] get all except 1

2004-07-20 Thread Dan McCullough
, 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:29 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: [PHP] get all except 1 Dan

Re: [PHP] get all except 1

2004-07-20 Thread John W. Holmes
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:

RE: [PHP] get all except 1

2004-07-20 Thread Dan McCullough
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