|
Posted by Simon on 10/19/05 17:42
> 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...
>
You are right, there are gaps in the sequence.
Simon
Navigation:
[Reply to this message]
|