[SOLVED] Quotations marks inside a MySQL database

[jandrews3]

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!

[peranha]

I addslashes on the input, and stripslashes on the output, there is probably a better way, but it works.