How do I need to handle a query to a mysql database when I know the returned data may possibly contain quotation marks?
Code:
$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!