SQL Help needed

so i have a database in my website with some categories
for example

"instagram likes"
"instagram followers"
"youtube views"
etc..

i want to rearrange them and put the "youtube views" on top but the problem is that in each index of the array there is a value that is connected to my api system and cant be changed it will mess up the orders

so my thought was to put an extra field as identifier and sort the arrays with that identefier..so i can have the desired result

no idea how to do this..anyone can help t
ty

What if you sort the rows by category alphabetically?

select * from Category
order by Category DESC

legion85 said:

What if you sort the rows by category alphabetically?

select * from Category
order by Category DESC

Click to expand...

am using phpmyadmin on plesk

does not matter, you can still run queries like that. if you're not familliar with phpmyadmin, try https://www.mysql.com/products/workbench/

Basically what legion85 is telling you is correct.
Go to phpmyadmin on Plesk.
Select the database that you want to work on
Then select the table that you want to work on, and then click on the SQL tab.
In that box there you enter the command that legion gave you, ie:

select * from youtube views
order by youtube views DESC

so i did what you said..but still no luck

i ended up creating a new field in the database "sort_id" and sorted them in descending ordder in the sql but the visual part still does not work

how can i sort them in the webpage?


this is the code i have in my php to show the services list , how can i sort those according to my new sort_id