i have a table of high scores on a game, if there is a new high score i want to move down all the entrys to make way for the new high score, is there an easy to move a row in a table(mysql) to another row?
In order to move rows in MySQL, you'd have to get all the info out of the table, delete everything from the table, then add all the data back in in the required order. It's MUCH MUCH easier to do it just like ~magicrobotmonkey suggested.
Real programmers don't comment their code. If it was hard to write, it should be hard to understand.
dull you seem to be missing the whole point of what a datbase is and does, that is why we have relational databases, you can get the infomation out in whatever order you want it in, regardsless of when it was added, as long as you have something to identify the order it should be in ie. the score or the percentage in this case.