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 'and modification_data.brand_id = 181 and modification_data.mod_id = modific' at line 3 Select modification.*, modification_data.fuel1 From modification_data, modification Where modification_data.fuel1 = and modification_data.brand_id = 181 and modification_data.mod_id = modification.id limit 0, 42