$ sqlsl =“select * from newmessage where sendto ='” . $ userid . “'order by inboxid limit 10”;
皮斯帮助我,
上表以ASC顺序检索我的badabase中的前10行 . 我的数据库包含100个记录 . 我只想在DESCing顺序中进行前10次录制
$sqlsl = "select * from newmessage where sendto='".$userid."' order by inboxid DESC limit 10";
请试试
"$sqlsl = "select * from newmessage where sendto='".$userid."' order by inboxid DESC limit 10";
请参阅MySQL文档中的this页面 .
要按降序获取记录,您应该将 DESC 关键字添加到 order by 子句:
DESC
order by
$sqlsl = "select * from newmessage where sendto='".$userid."' order by inboxid desc limit 10";
用这个
select * from(select * from newmessage where sendto ='“ . $ userid . ”'order by inboxid limit 10)as message_id order by message_id desc
4 回答
请试试
请参阅MySQL文档中的this页面 .
要按降序获取记录,您应该将
DESC
关键字添加到order by
子句:用这个
select * from(select * from newmessage where sendto ='“ . $ userid . ”'order by inboxid limit 10)as message_id order by message_id desc