Unknown column 'login_register.php' in 'where clause'<br/><br/>SELECT DISTINCT(pkBatteryID), fkBatteryBrandID, BatteryModel, BatteryType, BatteryImage, BatterySpecification, BatteryCapacity, BatteryWarranty,  BatteryCityPrice_MRP, BatteryCityPrice_WithPrice, BatteryCityPrice_WithoutPrice, BatteryBrandTitle FROM batteries 
LEFT JOIN battery_brands ON batteries.fkBatteryBrandID = battery_brands.pkBatteryBrandID 
LEFT JOIN battery_types ON batteries.fkBatteryTypeID 	 = battery_types.pkBatteryTypeID INNER JOIN battery_prices ON  battery_prices.fkBatteryID = batteries.pkBatteryID WHERE   BatteryStatus = "Active"  AND batteries.fkBatteryTypeID=login_register.php AND battery_prices.fkCityID ='1' AND battery_brands.BatteryBrandStatus= "Active" AND batteries.fkBatteryBrandID='3'  ORDER BY BatteryCityPrice_MRP ASC