![](images/2.jpg)
数据库操作出错:1054 -> Unknown column 'f_rzj' in 'where clause'
select ID,Title,Subtitle,Attach,Pubdate,h.f_type,h.f_address,h.f_wuye,h.f_kfs,b.h_gongwei,b.h_huanxian,h.f_zhuangx,b.h_huxing,b.h_mianj,h.f_shangq,h.f_area,h.f_louc,h.f_louceng,h.f_jgsj,b.h_price,b.h_rzj,b.h_yzj,u.Name,u.Tel,u.Email from tab_news a join tab_news_jichu b on a.ID=b.InfoID join tab_webmaster u on a.AdmiinID=u.AdminID join tab_define_jichu h on a.BuildingID=h.InfoID where 1=1 && b.h_mianj >= 100 && b.h_mianj < 300 && f_rzj > 0 && b.h_rzj < 3 && h.f_area = 56 && a.State = 1 order by a.DataOrder asc ,ID Desc limit 0,8
数据库操作出错:1054 -> Unknown column 'f_rzj' in 'where clause'
Select ID,Title,Subtitle,Attach,Pubdate,h.f_type,h.f_address,h.f_wuye,h.f_kfs,b.h_gongwei,b.h_huanxian,h.f_zhuangx,b.h_huxing,b.h_mianj,h.f_shangq,h.f_area,h.f_louc,h.f_louceng,h.f_jgsj,b.h_price,b.h_rzj,b.h_yzj,u.Name,u.Tel,u.Email from tab_news a join tab_news_jichu b on a.ID=b.InfoID join tab_webmaster u on a.AdmiinID=u.AdminID join tab_define_jichu h on a.BuildingID=h.InfoID where 1=1 && b.h_mianj >= 100 && b.h_mianj < 300 && f_rzj > 0 && b.h_rzj < 3 && h.f_area = 56 && a.State = 1