Solarpitch Posted April 18, 2008 Share Posted April 18, 2008 Hey guys, I am having a problem with a certain type of name taking to the database. The query is something like... $sql = "INSERT INTO golfpro_time_sheet VALUES('".$date."','".$time."','".$member_name1."','".$gui1."'....... If $member_name1 has the value of John O'Sullivan for example, it wont enter into the database because the apostrophe in O'Sulilivan is causing the statement to close.... // echo sql... INSERT INTO golfpro_time_sheet VALUES('04182008','7:00','O'Sullivan John Mr','20930380'.......... // you can see above how its messing with the insert, is there anyway around this? Quote Link to comment https://forums.phpfreaks.com/topic/101726-solved-small-syntax-question/ Share on other sites More sharing options...
Daniel0 Posted April 18, 2008 Share Posted April 18, 2008 Just escape the string. If you're using PDO, use prepared statements. If you're using the mysql extension, use mysql_real_escape_string(). Quote Link to comment https://forums.phpfreaks.com/topic/101726-solved-small-syntax-question/#findComment-520451 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.