首页横排美化+ 横排板块显示最后发表主题五笔 for 6.0 (完美修正!!)

非常好！！我喜欢！！我也试一下！

很好，谢谢楼主，并期待升级版

Discuz! info: MySQL Query Error


Time: 2008-2-28 10:23am
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='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='9' 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='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='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='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='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='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='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='30' 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='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='12' 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='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='20' 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) UNION (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='24' 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='25' 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='26' 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='29' 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) (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='9' 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='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='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='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='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='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='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='30' 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='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='12' 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='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='20' 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) UNION (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='24' 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='25' 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='26' 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='29' 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)
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 O
Errno.: 1064

Similar error report has beed dispatched to administrator before.

没有
有新帖和无新贴显示图标了

修改的程序过多，容易引起混乱

测试了5.5也一样能用，不过就是不怎么好看！！！
http://fzl860.h100.f5w.net/index.php

很好的帖子，收藏！！！！

可以啦
还满漂亮嘛
http://442200.oicp.net/index.php

[ 本帖最后由 hengsy 于 2008-3-3 20:50 编辑 ]

请问怎样让图示的主题 / 帖数下面的数字弄成一排显示，期待高手作答，谢谢