MySQL Forums
Forum List  »  PHP

Help Sorting Order of Tables in SQL
Posted by: Gordon Donaldson
Date: March 25, 2021 09:19AM

Hello, I was wondering if anyone knew how I could order the table in my database by the scores while also keeping a 1-60 order with the id numbers?

Like when I insert an entry if the score is higher than the others I want it to be inserted at the top with the id number 1.

Right now when I insert a value and the score is higher it just goes on the end with an id of 61.

I have the ids set up to auto-increment. But I need the order to be highest to lowest score as well.

Anyone know how to make this happen?

Options: ReplyQuote


Subject
Written By
Posted
Help Sorting Order of Tables in SQL
March 25, 2021 09:19AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.