[thelist] Fetching rows 5 above and 5 below a target row...

[Tris]

Ok, scratch that, I've just gourped them and giventhem al the same position No..

Cheers for the suggestion..!!!

On 18/12/06, Tris <beertastic at gmail.com> wrote:
> Currently, the DB query jsut lists though with the same score, in the
> order they registered...
> I cannot really see a fair way to rank users with the same score..
> hmm...
> What to do...
>
>
> On 18/12/06, Matt Warden <mwarden at gmail.com> wrote:
> > On 12/18/06, Tris <beertastic at gmail.com> wrote:
> > > I see...
> > > I can then adda  limit 10 to only fetch the correct No of rows..
> > > However, that page dies not seem to say how to ensure my result sits
> > > in teh middle..
> > >
> > > If every user has a score of 100, it'll pick out the first 10 only..
> > > that's not good...
> >
> > If every user has the same score, how do you determine rank? We would
> > need this information.
> >
> > --
> > Matt Warden
> > Cleveland, OH, USA
> > http://mattwarden.com
> >
> >
> > This email proudly and graciously contributes to entropy.
> > --
> >
> > * * Please support the community that supports you.  * *
> > http://evolt.org/help_support_evolt/
> >
> > For unsubscribe and other options, including the Tip Harvester
> > and archives of thelist go to: http://lists.evolt.org
> > Workers of the Web, evolt !
> >
>