ASC and DESC

[Drezard]

Hello, Im writing a small message board and im using the Time() function to get the timestamp and then im storing it in the database with the message.

 

Now, i want to retrieve the latest messages (the latest ones inputted)...

 

So basically my query is something like:

 

SELECT message FROM message_board WHERE time=

 

but thats as far as ive gotten. Can someone help me finish this query?

 

- Cheers, Daniel

[Rizla]

$query = "SELECT * FROM message_board ORDER BY id DESC";

$result = mysql_query($query)or die(mysql_error());

 

then use a while loop to print all your data

[opels]

or modifiy it slightly to retrieve the last 10 messages,

 

$query = "SELECT * FROM message_board ORDER BY id DESC LIMIT 10";