calabiyau Posted February 14, 2007 Share Posted February 14, 2007 I'm making a blog where I can type into a text area, submit the form and process it by inserting it into my database. Problem is if my blog entry has any apostrophe's in it it stops the query from processing. Anyone can tell me why it is doing this and what to change to stop it from happening? include('../connections.php'); //soft string is the text area variable posted $softstring = $_POST['softstring']; $new_page = $_POST['new_page']; $query = "INSERT INTO ".$new_page." VALUES (' ','$softstring')"; if (mysql_query($query, $connect)) { echo "<p>code inserted into".$new_page."</p>"; } Quote Link to comment Share on other sites More sharing options...
Jessica Posted February 14, 2007 Share Posted February 14, 2007 http://php.net/mysql_real_escape_string Quote Link to comment 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.