1 Replies - 306 Views - Last Post: 26 October 2017 - 08:03 AM Rate Topic: -----

#1 Natalie198415090  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 1
  • Joined: 26-October 17

How To Create A Leaderboard using ASP

Posted 26 October 2017 - 07:58 AM

Hi,

I was wondering how to create a simple leader board for the website I am creating?

I wish to list all users in order (most posts to least) and the username and number of posts will be viewable in the leader board, with the highest number of posts amount being #1 in rank, all the way down to the bottom (fewest number of posts)

The information is just inside a database table! I can't connect to the individual value to store it in the live program, then delete the value on the database, then increment the live value by one, and insert it back into the database!

Thanks so much in advance everyone,

Nat

Is This A Good Question/Topic? 0
  • +

Replies To: How To Create A Leaderboard using ASP

#2 modi123_1  Icon User is offline

  • Suitor #2
  • member icon



Reputation: 13493
  • View blog
  • Posts: 53,899
  • Joined: 12-June 08

Re: How To Create A Leaderboard using ASP

Posted 26 October 2017 - 08:03 AM

What's this talk about 'individual value'? It should be a pretty straight forward SQL call using COUnT and group by user id.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1