MySQL Query : SELECT COUNT(*) AS num FROM `www_00769_com_cn`.`v9_rent` WHERE `status` = '99' AND `bedroom` >= '6' AND `bedroom` < '100' AND `fanshi` = '1' AND `fittype` = '4' AND `price` >= '2000' AND `price` < '3000' AND `shuxing` = '2' AND `zone` in(3372) and `catid`='81' LIMIT 1 MySQL Error : Unknown column 'fittype' in 'where clause' MySQL Errno : 1054 Message : Unknown column 'fittype' in 'where clause' Need Help?