get last 10 rows in database but order opposite

[jwk811]

i did this

$sql="SELECT * FROM chat_messages ORDER BY message_id DESC LIMIT 10";

 

but i want those last 10 rows that im taking to be ordered the opposite way. if i use ASC it gives me the first 10 rows in the table

[jwk811]

nevermind i got it. i did this

 

$sql = "SELECT * FROM chat_messages";
$result = mysql_query($sql);
$num = dbNumRows($result);

$last = 10;
$num = $num - $last;

$sql="SELECT * FROM chat_messages ORDER BY message_id ASC LIMIT $last,$num";

[Psycho]

No, that is inefficient. You only need to do a single query. The exact same question was asked just a couple days ago and a solution provided:

http://www.phpfreaks.com/forums/index.php/topic,300778.msg1423631.html#msg1423631

 

SELECT *
FROM (SELECT * FROM chat_messages ORDER BY message_id DESC LIMIT 10) as last10
ORDER BY last10.message_id ASC

 

[fenway]

nevermind i got it. i did this

 

$sql = "SELECT * FROM chat_messages";
$result = mysql_query($sql);
[/quote]

Yeah, horrible idea -- get back every single record just to get a count?