Sotring a db Table

['LinKin]

Hello,

I use the SQL functions by default for MTA.

I have a table.

I want it so that when a player clicks Tops>SelectedValue*

Note: SelectedValue is the column which you want to recieve tops of. (1st, 2nd, 3rd, Playtime, etc..)

It shows the Top 10 players regarding the SelectedValue.

How can I make this? Sort the table by the selected column and printing the first 10 lines? Or anyother way?

Thanks

[Castillo]

Depends on how you are storing these values.

You can use "ORDER BY" in the query.

Example:

SELECT account, myValue FROM myTable ORDER BY myValue DESC LIMIT 10 

[Bonsai]

local result = executeSQLQuery("SELECT playerName, timeText, dateRecorded, extra  FROM ? ORDER BY timeMS ASC LIMIT 10", mapname ) 
  

This is what I do in my toptimes script.

['LinKin]

So

ASC Ascendent order

DESC Descendent order

LIMIT : Number of results to display? (i.e. 1st ten tops = LIMIT 10)

Thanks a lot Solid and Bonsai, let's live together bons))

[Castillo]

You're welcome.

['LinKin]

local result = executeSQLQuery("SELECT playerName, timeText, dateRecorded, extra  FROM ? ORDER BY timeMS ASC LIMIT 10", mapname ) 
  

This is what I do in my toptimes script.

If I wanted to sort the the entire table, (without limit) would I be able to do so just by deleting "LIMIT 10" from the Query?

[Bonsai]

Yep

[Castillo]

That won't limit to sort only 10, it'll limit the amount of rows it'll return.