how to write the code in php that get the articles' title with the most replies in latest one week in mysql? eg: the table name is "threads". the time field is "dateline" whose style is like this (1300774889), the article title is "subject". the reply field " replies" thank you.i want to get 10 records.