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

Tris beertastic at gmail.com
Mon Dec 18 11:25:49 CST 2006


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 !
>



More information about the thelist mailing list