为什么我在INDEX。PHP里加入那段代码以后
论坛不能正常显示了,出现:Discuz! info: MySQL Query Error
User: 老眯
Time: 2008-7-22 9:35am
Script: /index.php
SQL: (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='18' 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='4' 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='23' 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='2' 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='3' 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='21' 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='16' 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='15' 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='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='44' 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='43' 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='36' 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='45' 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='11' 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='13' 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='22' ORDER BY t.dateline DESC LIMIT 5) (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='18' 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='4' 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='23' 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='2' 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='3' 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='21' 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='16' 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='15' 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='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='44' 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='43' 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='36' 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='45' 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='11' 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='13' 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='22' 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
Errno.: 1064
Similar error report has beed dispatched to administrator before.
免费注册贴客帐号
阅读贴客必读了解“贴客”
碰到问题发贴联系管理员
填写调查表格成为正式贴客
挑选广告贴身赚取油钱
报名参加贴客活动认识朋友
讲述自己的贴客经历
发布照片展示自己爱车靓影
谈天说地赚贴客币有更多惊喜
女人的世界女人作主
来淘下宝看有没好东西
理财、股票总是最热门话题
|