how to order from newest to oldest

[Tewl]

i'm making a small msg board, and im tryin to figure out how to list
the posts from newest to oldest instead of the other way around.

my current table is this:

create table mgs (
  id int(11) not null auto_increment,
  date int(11) not null,
  msg text,
  primary key(id)
);

[morrisoner]

SELECT * FROM table WHERE condition ORDER BY date DESC

[Quevas]

ORDER BY id DESC

[JakesSA]

Like they said above, the best way would be to order by you ID that you sending ito you db ... and if you are trying to find the newest one added to you db, use your mysql_affected_rows