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 '-10,10' at line 8 - Execute Query False! Select soft_archives.ID,soft_archives.title,soft_archives.typeid,soft_archives.ismake,soft_archives.money,soft_archives.color,
soft_archives.description,soft_archives.pubdate,soft_archives.senddate,soft_archives.arcrank,soft_archives.click,
soft_archives.litpic,soft_arctype.typedir,soft_arctype.typename,soft_arctype.isdefault,
soft_arctype.defaultname,soft_arctype.namerule,soft_arctype.namerule2,soft_arctype.ispart,
soft_arctype.moresite,soft_arctype.siteurl
from soft_archives
left join soft_arctype on soft_archives.typeid=soft_arctype.ID
where soft_archives.arcrank > -1 And ( (CONCAT(soft_archives.title,' ',soft_archives.description,' ',soft_archives.writer,' ',soft_archives.source) like '%309%' Or CONCAT(' ',soft_archives.keywords,' ') like '%309 %') ) order by soft_archives.sortrank desc limit -10,10