Simple SQL question.

[gaza165]

i need to use an sql query to select the last 10 from my database but need it in ascending order.

 

 

$sql = "SELECT * FROM chat ORDER BY chat_id LIMIT 0,10";

 

i know this will select the records from 0,10 but in my db they are like this

 

id    MESSAGE

 

1    FIRST

2    SECOND

3      THIRD

4    Fifth

 

basically, the older the post i dont want it to be displayed. i want the most recent 10 records that are in the database.

 

sorry i havent explained clearly.

[Yesideez]

You'll have to read them into an array and reverse the array - only way I can think of doing it.

 

$sql = "SELECT * FROM chat ORDER BY chat_id LIMIT 0,10 DESC";

[redarrow]

Next time use a time stamp in the database.

 

it would of made life so easier.

[gaza165]

i am using timestamp in my database, shall i order it by timestamp??