sherrilljj Posted July 27, 2007 Share Posted July 27, 2007 Hello, everyone I am using mysqli_query to call a stored procedure, passing some variables. The codes appear as below Mysqli_query($link,"call SPName('$VariableA')"); The value of $VariableA contains single quotes, such as $VariableA="Sth'S" Then the system gets confused: call SPName(\'Sth\'S\')can not execute the SP. Errorcode : 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 \'S\')\' at line 1 Anyone knows how to solve this problem? Thanks in advance. Best Link to comment https://forums.phpfreaks.com/topic/62041-solved-single-quotes/ Share on other sites More sharing options...
Wildbug Posted July 27, 2007 Share Posted July 27, 2007 Try using escaped double-quotes in the query. mysqli_query($link,"call SPName(\"$VariableA\")"); Link to comment https://forums.phpfreaks.com/topic/62041-solved-single-quotes/#findComment-308914 Share on other sites More sharing options...
sherrilljj Posted July 27, 2007 Author Share Posted July 27, 2007 Thanks a lot! It works Link to comment https://forums.phpfreaks.com/topic/62041-solved-single-quotes/#findComment-309054 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.