MYsQL数据库问题，请各位老大帮忙

[Type]查询语句错误[1064]YouhaveanerrorinyourSQLsyntax;checkthemanualthatcorrespondstoyourMy... [Type] 查询语句错误
[1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DESC LIMIT 0, 10' at line 1
[Query] SELECT t.*, f.name FROM forum_thread t, forum_forum f WHERE f.status<>'3' AND f.fid=t.fid AND t.displayorder not IN(-1,-2) AND t.replies!=0 AND t.dateline>0 ORDER BY t. DESC LIMIT 0, 10
Discuz! Database Error The database has encountered a problem. Need Help?Error messages: [Type] 查询语句错误
[1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DESC LIMIT 0, 10' at line 1
[Query] SELECT t.*, f.name FROM forum_thread t, forum_forum f WHERE f.status<>'3' AND f.fid=t.fid AND t.displayorder not IN(-1,-2) AND t.replies!=0 AND t.dateline>0 ORDER BY t. DESC LIMIT 0, 10 Program messages: [Line: 0055]forum.php(runhooks)
[Line: 1188]source\function\function_core.php(hookscript)
[Line: 1230]source\function\function_core.php(plugin_thread_list_forum->index_top)
[Line: 0109]source\plugin\thread_list\thread_list.class.php(thread_list_query)
[Line: 0019]source\plugin\thread_list\thread_list.func.php(DB::query)

我QQ420398323 ，谢谢展开

 我来答

1个回答

#热议# 空调使用不当可能引发哪些疾病？

百度网友38cb4ea
2012-08-21 · 超过74用户采纳过TA的回答

知道小有建树答主

回答量：170

采纳率：0%

帮助的人：196万

我也去答题访问个人页

关注

展开全部

SELECT t.*, f.name FROM forum_thread t, forum_forum f WHERE f.status<>'3' AND f.fid=t.fid AND t.displayorder not IN(-1,-2) AND t.replies!=0 AND t.dateline>0 ORDER BY t. DESC LIMIT 0, 10

你这个有语法错了
order by 后面没字段了！！！