要做一个站内搜索引擎,MYSQL两表同时查询给出结果,代码如下:
(SELECT * FROM `#@__infoimg` WHERE title LIKE '%$keyword%' AND delstate='' AND checkinfo=true
) UNION ALL (SELECT * FROM `#@__infolist` WHERE title LIKE '%$keyword%' AND delstate='' AND checkinfo=true
) ORDER BY ID DESC
运行出现错误,请高人指点!!!