Posted by Oli Filth on 10/19/05 17:31

Gerard wrote:
> Providing that u know what xx is there two other needed variables are
> the xx-5 and xx+5
>
> so then
>
> $start = $xx-5;
> $stop = $xx+5;
>
> SELECT * FROM Articles WHERE id >= $start AND id <= $stop;
>
> I think this is what you're looking for.
>

This assumes, of course, that there are no gaps in the sequence of
IDs...

--
Oli

[Back to original message]