数据库问题MySQLQuery:selecta.url,a.thumb,a.title,b.pricestartfromhousecontenta,housechousMySQLQuery:selecta.url,a.thumb,a.title,b.pricestartfromhousecontenta,housechousebwherea.contentid=b.contentidandcatid=20andareaid=1

Question

数据库问题MySQL Query :select a.url,a.thumb,a.title,b.pricestart from house_content a,house_c_hous
MySQL Query :select a.url,a.thumb,a.title,b.pricestart from house_content a,house_c_house b where a.contentid=b.contentid and catid=20 and areaid=1 and a.contentid and status=99 order by a.posids desc,a.contentid desc LIMIT 5
MySQL 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 'and status=99 order by a.posids desc,a.contentid desc LIMIT 5' at line 1
MySQL Errno :1064
Message :MySQL Query Error
这是什么问题呢?请大虾们帮帮

Answer 1

明显 and 语法错误啊!
另外,status是保留字,建议别用在字段名上