SELECT p.*,d.title FROM wiki_attachment p,wiki_doc d,wiki_category ca,wiki_categorylink cl WHERE p.did=d.did AND ca.cid=cl.cid AND cl.did=d.did AND ca.type=1 AND p.state=0 AND p.isimage=1 AND p.did0 ORDER BY time DESC LIMIT 2,9刚一运行就报错了。Unknown column 'ca.type' in 'where clause'
SELECT p.*,d.title FROM wiki_attachment p,wiki_doc d,wiki_category ca,wiki_categorylink cl WHERE p.did=d.did AND ca.cid=cl.cid AND cl.did=d.did AND ca.type=1 AND p.state=0 AND p.isimage=1 AND p.did0 ORDER BY time DESC LIMIT 2,9刚一运行就报错了。Unknown column 'ca.type' in 'where clause'
还可以 有一定的指导作用
没用上，还是下了个互动的。