Discuz! info: MySQL Query Error
Time: 2009-1-7 8:51pm
Script: /bbs/pic.php
SQL: SELECT attach.aid, attach.attachment, t.tid, t.fid, t.subject FROM [Table]attachments attach LEFT JOIN [Table]threads t ON t.tid=attach.tid WHERE attach.readperm='0' AND displayorder>='0' filetype LIKE 'image/%' AND t.fid IN (9,10,22) GROUP BY attach.tid ORDER BY attach.dateline DESC LIMIT 18
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 'filetype LIKE 'image/%' AND t.fid IN (9,10,22) GROUP BY attach.tid ORDER BY atta' at line 1
Errno.: 1064