Posted by Jason Petersen on 02/18/05 06:02

On 17 Feb 2005 19:28:18 -0600, Bret Hughes <bhughes@elevating.com> wrote:
> On Thu, 2005-02-17 at 18:24, Sebastian wrote:
> > Hello,
> > im working on an article system and looking to avoid running three queries.
> > example, i have this query:
> >
> > SELECT id,title FROM articles WHERE id=$_GET[id]
> >
> > now say $_GET[id] = 5
> >
> > I would like to get the previous id 4 and the next id 6 (if there is one)
> > so i can do something like:

I would do something like:

$theId = $_GET['id'];
$ids = $theId-1 . ", ". $theId ", ". $theId+1;
$query = "SELECT id, title FROM articles WHERE id IN ($ids)";

[Back to original message]