UBB.Dev
Posted By: JoshPet Help with a Query - 08/24/2003 8:01 PM
Hey - I'm not sure how to easily do this.....

But I want to Order a list of results and then say You placed 172 out of 220.

After I order the database... how can I find out what position their total is.

Not sure If I explained it right. This is for something else.... but as an example... I want to order the list of people here by Post Count.

Then when Navaho logs in, I want it to say "You placed 303 out of 2000."

But I'm not sure how to efficiently do that.
Posted By: JustDave Re: Help with a Query - 08/24/2003 8:09 PM
I'm stumped.

I have a long-way-around solution but I don't think you would like it... LoL
Posted By: JoshPet Re: Help with a Query - 08/24/2003 8:49 PM
Yeah, my "long way" would be to "count" through all the results and see where it places. Kind of a lot of work.
Posted By: JoshPet Re: Help with a Query - 08/24/2003 8:49 PM
If there's no easy way.... I might have to do that and cache it so it's only done once per day.
© UBB.Developers