php ==> mysql: sorting the data?

Question

i am trying to sort the data by time:.
i want it to show the new ones first but it shows the old ones first.
anybody can help? this is my code:
$data = mysql_query ("SELECT * FROM clanforum WHERE clan = '$clan' ORDER BY time");

Answer 1

change your query to ORDER BY time DESC

Answer 2

Right query:
$data = mysql_query ("SELECT * FROM clanforum WHERE clan = '$clan' ORDER BY time DESC");