DataBase error - Table 'iay.tblsettingvalue' doesn't exist select tblsettingvalue.settingvalue from tblsettingvalue
left join tblsetting on tblsettingvalue.settingid = tblsetting.settingid
where tblsetting.parameter = 'frontend_pagelength' DataBase error - Table 'iay.tblfamily' doesn't exist Select count(*) from tblfamily where (tblfamily.villagecode = '501010010004') and tblfamily.socialgroup in('1','2')DataBase 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 '' at line 13 select familyid, familycode, fathername, headname,totalfamilymember,totscore, tblfamily.landtypeid, tblfamily.socialgroup, tblfamily.villagecode, tblfamilyhindi.headinhindi,tblfamilyhindi.fatherinhindi, tblsocialstatus.socialdescinenglish, tbllandtype.landdescinenglish, tblincome.incomeinenglish,gps,photo from tblfamily
left join tblfamilyhindi on tblfamilyhindi.familyhindiid = tblfamily.familyhindiid
left join tblvillages on tblvillages.villagecode = tblfamily.villagecode
left join tblsocialstatus on tblsocialstatus.socialgroup = tblfamily.socialgroup
left join tbllandtype on tbllandtype.landtypeid = tblfamily.landtypeid
left join tblincome on tblincome.incomecodeid = tblfamily.incomecodeid
where (tblfamily.villagecode = '501010010004') and tblfamily.socialgroup in('1','2') Limit 0,
Web Based Project Management System