hi i got this in my mail when user try to sibscribe : database error query
Query:
SELECT `m`.`country` FROM `bx_map_cities` AS `m` WHERE `m`.`country` = 'CA' AND `m`.`city` = 'l'Assomption' AND `m`.`failed` = 0 LIMIT 1
Mysql 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 'Assomption' AND `m`.`failed` = 0 LIMIT 1' at line 1
i added this just before the quey to resolve it :
$sCity = addslashes($sCity);
ty
popy
