Creating a sql request from a numeric value field

[papidjo1456]

Hello,
I need help please.
You will notice in the presentation below that the higher the value of the ‘’ id ‘’ field, the more the value of the ‘’ number ‘’ field grows. Then I want to create an SQL query that would allow me to display on my web page all the values ​​of the ‘’ content ‘’ fields in descending order without using the field ‘’ id ‘’ as a timeline but rather the field ’ ‘number’.
Thank you for helping me.
Here is a presentation of one of my tables in the database of my site:

Id = 1 number = 1495898689 content = hello
Id = 2 number = 1495899357 content = my school
Id = 3 number = 1495900012 content = my name
Id = 4 number = 1495903236 content = super

[benanamen]

What have you tried? We are not going to do your homework for you.

[Cluster_One]

HI,

This will not hurt to read it first:
https://www.w3schools.com/php/php_mysql_select.asp

I think it needs to:
select two columns(guess which) from table(guess which) order by column you wish to use to sort the data desc

But obviously, you have already figured this out all by yourself, haven’t you?