order by and limit condition in mysql

$sqlsl = "select * from newm开发者_如何学Pythonessage where sendto='".$userid."' order by inboxid limit 10";

Pease help me,

Above table retrieve first 10 rows in my badabase in ASC order. My database contain 100 recordes. I want only first 10 recordes in DESCing order

---

$sqlsl = "select * from newmessage where sendto='".$userid."' order by inboxid DESC limit 10";

---

Please try

"$sqlsl = "select * from newmessage where sendto='".$userid."'
order by inboxid  DESC limit 10";

See this page in the MySQL documentation.

---

To get the records in descending order you should add the DESC keyword to the order by clause:

$sqlsl = "select * from newmessage 
where sendto='".$userid."' 
order by inboxid desc 
limit 10";

---

Use this

select * from (select * from newmessage where sendto='".$userid."' order by inboxid limit 10) as message_id order by message_id desc