mysql syntax error when try insert ' symbol
Posted: Sun Apr 16, 2006 6:33 am
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') ";
$Name="my'name";
$this->query = "INSERT INTO Rooms (Name) VALUES ('$Name') ";