Page 1 of 1

mysql syntax error when try insert ' symbol

Posted: Sun Apr 16, 2006 6:33 am
by aigarzzz
how can i save in mysql db string where is ' symbol? every time i want do it, it genereates error, for example
$Name="my'name";
$this->query = "INSERT INTO Rooms (Name) VALUES ('$Name') ";

Posted: Sun Apr 16, 2006 7:05 am
by Benjamin

Code: Select all

mysql_real_escape_string($Name);