[SOLVED] mysql fetch array opposite

[SN1P3R_85]

hi everybody, i have a mysql table that is sorted by Id, that auto increments. I want to put the rows into an array, and then print elements from each row, but if i did this the normal way, it would print elements from Id 1, then Id 2, then Id 3, etc. I want it to do the opposite, so start with the highest, and print it all until it reaches the lowest Id. how would i do this? thanks

[Third_Degree]

ORDER BY `id` DESC

[trq]

You would do this with your query. eg;

 

SELECT data FROM tbl ORDER BY id DESC

[SN1P3R_85]

so the DESC makes it add new data to the top?

[Third_Degree]

no it simply returns the records in order of highest id to lowest id.

[SN1P3R_85]

oh, thanks alot, i'll try it right now

[SN1P3R_85]

yep, it works, thanks alot. I was bothering with the php when i could have done this the whole time hehe