Topic: get last 10 rows in database but order opposite

[jwk811]

i did this

Code: [Select]

$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

Code: [Select]

$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

Code: [Select]

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

Code: [Select]

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

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