Blacklists

[dean7]

Hi all, I want to create something for my website which shows the user with the most money etc... So the user with the most cash in the game would be first on the blacklist the the person with then 2nd most cash would be 2nd on the blacklist etc..

 

But how could i code this?

 

Thanks for your help.

 

[Ken2k7]

A simple database table that keeps track of who has what. Then query it. Do you have a more specific question that I can give a more specific response to?

[Pikachu2000]

Assuming this is database driven: "SELECT username FROM table ORDER BY money DESC" would return the results you need.

[dean7]

Assuming this is database driven: "SELECT username FROM table ORDER BY money DESC" would return the results you need.

But from that how would I display it in a table with the person with most money at the top?

[Pikachu2000]

The ORDER BY clause sorts it by the field specified, then the DESC parameter sorts it in descending order. You'd just echo it out in a while{} loop as you would any other time.

[dean7]

The ORDER BY clause sorts it by the field specified, then the DESC parameter sorts it in descending order. You'd just echo it out in a while{} loop as you would any other time.

 

Ok thanks . Ill give it a go