DataBase error - Table 'iay.tblvillages' doesn't exist select villagecode, villages from tblvillages where isactive = 'Yes' order by villagesDataBase 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.totscore in('1','2','3','4','5','6','7','8','9','10','11','12','13') and tblfamily.socialgroup in('3','4','5','6')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, tblfamilyhindi.headinhindi,tblfamilyhindi.fatherinhindi, tblfamily.landtypeid, tblfamily.socialgroup, tblfamily.villagecode, tblsocialstatus.socialdescinenglish, tbllandtype.landdescinenglish, tblincome.incomeinenglish 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.totscore in('1','2','3','4','5','6','7','8','9','10','11','12','13') and tblfamily.socialgroup in('3','4','5','6') Limit 0,
Web Based Project Management System