https://www.webmaster-forums.net/crss/node/1037189 en https://www.webmaster-forums.net/serverside-scripting/sorting-list-or-db-numericly-and-displaying-it-table-browserbest-way-do-it#comment-1213553 <p>that sounds quite simple but where do I put the SELECT * FROM Results ORDER BY Points DESC LIMIT 10<br /> How do i setup a database and i dont know any php to create a script to import the data <img src="https://www.webmaster-forums.net/misc/smileys/confused.png" title="Confused" alt="Confused" class="smiley-content" /></p> Mon, 15 Jan 2007 17:09:09 +0000 andreww87 comment 1213553 at https://www.webmaster-forums.net https://www.webmaster-forums.net/serverside-scripting/sorting-list-or-db-numericly-and-displaying-it-table-browserbest-way-do-it#comment-1213549 <p>On your homepage, if you imported the data to a database, getting the top 10 is as easy as:</p> <p>SELECT * FROM Results ORDER BY Points DESC LIMIT 10</p> <p>Then step through the records and display accordingly.</p> <p>A simple php script could be used to import a .txt file into a database.</p> Mon, 15 Jan 2007 16:15:23 +0000 pr0gr4mm3r comment 1213549 at https://www.webmaster-forums.net