about displaying

[hanwei]

hi, i have a small question.

i have created a table to be displayed in my php script. The data displayed is from my mySQL database. I do a select * to display all the result on my table. And my table looks like this:

---

1. AAA xxx xxx xxx
2. BBB xxx xxx xxx
3. CCC xxx xxx xxx
4. DDD xxx xxx xxx
5. EEE xxx xxx xxx
   --------------------------------
   The numbering is from the smallest to the largest. So i would like to know is there any method to make the numbering from the largest to the smallest?? Because whenever a data is inserted to my database, the number will automatically increase, so i would like to display the recent data that have been created. Can anyone teach me how to do it??

e.g

5. EEE xxx xxx xxx
6. DDD xxx xxx xxx
7. CCC xxx xxx xxx
8. BBB xxx xxx xxx
9. AAA xxx xxx xxx
   --------------------------------
   thanks in advance..😃

[ClarkF1]

do you have a column in the database with the numbers in it.

If so you could easily add "ORDER BY id DESC" to the query, where id is the name of the column with the numbers.

[hanwei]

ic.. DESC means to start from the largest number? i get it.. thanks..😃

[ClarkF1]

DESC = descending
ASC = ascending

🙂