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
Navigation:
[Reply to this message]
|