SA-MP Forums Archive
How can I index (search) trought mysql database and to find best values of every column? - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: How can I index (search) trought mysql database and to find best values of every column? (/showthread.php?tid=651217)



How can I index (search) trought mysql database and to find best values of every column? - Zeus666 - 15.03.2018

I want to make a search, echoing data's in the descending way

Exemple: Column Money.

John has age 1000
Jahon has age 2000
Loku has age 3000.

I want to echo echo "money" by the highest number

How can this be achieved?

I want to make a top 10 rich list, and I want to make them descreasing

List will look like:

Loku: ?php echo $Loku Money?>
Jahon: ?php echo $Jahons Money?>
John: ?php echo $Johns Money?>.

but when database updates, the values from list will change too, even username