jandrews3 Posted July 21, 2008 Share Posted July 21, 2008 How do I need to handle a query to a mysql database when I know the returned data may possibly contain quotation marks? $query1 = "SELECT * FROM photo_log WHERE name = '$version'"; $result1 = mysql_query($query1) or die("Could not perform query: ".mysql_error()); $row1 = mysql_fetch_array($result1); The returned data is cut off from the point of a quotation mark. THE DATA IS: ITHF's "The Buth" at 2007 Convention. If I try add slashes after the query, I get: ITHF\'s \ I've tried a bunch of different approaches, but frankly this kind of problem has always confused me. My global_pc and global_runtime are both turned off. Sorry to be a bother! Thanks! Quote Link to comment Share on other sites More sharing options...
peranha Posted July 21, 2008 Share Posted July 21, 2008 I addslashes on the input, and stripslashes on the output, there is probably a better way, but it works. 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.