Posted by macca on 10/06/07 21:15

>select casualtyID, deathdate from the_table order by deathdate


Just to eloborate on that you can use the keywords ASC and DESC for
ascending order and descending order respectively, such as

"SELECT casualtyID, deathdate FROM the_table ORDER BY deathdate ASC"

• Next in forum: Re: Ranking function in PHP/MySQL
• Prev in forum: Script Modeling (UML)
• Thread view: Re: Ranking function in PHP/MySQL

[Reply to this message]