Posted by Simon on 10/19/05 17:41

> 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.
>
> Rgds,
> Gerard

I know what XX is but unfortunately the unique ID are not in sequence.

So I could have articles with ID

1, 4, 5, 6, 10, 11, and so on...

I don't have all the article numbers, (in the case above I don't have ID 2,
3, 7, 8 and 9).

So doing your select would not work.

Thanks

Simon

• Next in forum: Re: SELECT * help needed.
• Prev in forum: Re: SELECT * help needed.
• Thread view: Re: SELECT * help needed.

[Reply to this message]