我使用了,怎么出现以下错误啊???- Discuz! info: MySQL Query Error
- User: admin
- Time: 2008-12-18 1:20pm
- Script: /bbs/index.php
- SQL: SELECT * FROM uchome_userapp WHERE uid=1 ORDER BY displayorder(SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='8' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='7' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='10' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='31' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='6' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='33' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='34' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='14' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='17' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='32' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='19' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='39' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='40' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='28' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='27' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='42' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='35' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='37' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='38' ORDER BY t.dateline DESC LIMIT 5)
- Error: 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 'SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WH' at line 1
- Errno.: 1064
复制代码 |