Posted by Sandman on 11/16/05 17:10

In article <1132113150.201641.49730@g44g2000cwa.googlegroups.com>,
"Joshie Surber" <joshiesurber@gmail.com> wrote:

> > have a smart SQL qquery that will fetch it correctly for me in one pass?
>
> If you are fairly sure that the IDs are sequential

Well, had you looked at my example data, you would have seen they are not. :P

> If they aren't sequential, make an educated guess about how
> insequential they are and grab 10 or so on each side and filter out all
> but the five you want in your script. It is a lot faster to grab a lot
> of stuff in one query and filter it in your script than to grab a
> little stuff in two or more queries.

"lots of stuff" could mean tens of thousands of posts, so that's not a good
idea.

what I would like is something like this:

select * from blog where member = 12 and category = 'Sports' and id = 12345
limit -5, 5;







--
Sandman[.net]

[Back to original message]