问题标题:
数据库问题MySQLQuery:selecta.url,a.thumb,a.title,b.pricestartfromhouse_contenta,house_c_housMySQLQuery:selecta.url,a.thumb,a.title,b.pricestartfromhouse_contenta,house_c_housebwherea.contentid=b.contentidandcatid=20andareaid=1
问题描述:
数据库问题MySQLQuery:selecta.url,a.thumb,a.title,b.pricestartfromhouse_contenta,house_c_hous
MySQLQuery:selecta.url,a.thumb,a.title,b.pricestartfromhouse_contenta,house_c_housebwherea.content id=b.contentidandcat id=20andarea id=1anda.contentidandstatus=99orderbya.posidsdesc,a.contentiddescLIMIT5
MySQLError:YouhaveanerrorinyourSQLsyntax;checkthemanualthatcorrespondstoyourMySQLserverversionfortherightsyntaxtousenear'andstatus=99orderbya.posidsdesc,a.contentiddescLIMIT5'atline1
MySQLErrno:1064
Message:MySQLQueryError
这是什么问题呢?请大虾们帮帮
聂伍兵回答:
明显and语法错误啊!
另外,status是保留字,建议别用在字段名上
点击显示
英语推荐
热门英语推荐