Hi guys,
I'm making a new game and for the first time I wish to have a high scores.
I'm up to the point now where I have passed all the data from Flash to PHP, PHP has verified the values have not been faked and is ready to insert them into a database.
Here is the problem, I want the database in order - with highest score as ID 1 and the lowest score at the end of the table.
The high scores database could possible be holding thousands of user details though - So the method I was going to use (reading them all and sorting them all) would not be very practical seems as I need to pass results back to flash.
How can I do this? Or is there a better method I can use?
I'm not really bothered what techniques I have to use because I'm all up for learning.
(Note: I'm currently testing on a local server).
I'm making a new game and for the first time I wish to have a high scores.
I'm up to the point now where I have passed all the data from Flash to PHP, PHP has verified the values have not been faked and is ready to insert them into a database.
Here is the problem, I want the database in order - with highest score as ID 1 and the lowest score at the end of the table.
The high scores database could possible be holding thousands of user details though - So the method I was going to use (reading them all and sorting them all) would not be very practical seems as I need to pass results back to flash.
How can I do this? Or is there a better method I can use?
I'm not really bothered what techniques I have to use because I'm all up for learning.
(Note: I'm currently testing on a local server).