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
4. DDD xxx xxx xxx
3. CCC xxx xxx xxx
2. BBB xxx xxx xxx
1. AAA xxx xxx xxx
--------------------------------
thanks in advance..:D

[HuggieBear]

Just use an ORDER BY clause in your sql statement...

[code]
SELECT column_name FROM table_name ORDER BY numeric_column DESC
[/code]

Regards
Huggie

[hanwei]

thanks alot :D.. i'll try tomorrow..