Quotations in a MySQL database

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!

What is returned when running that query directly on the MySQL CLI? Or in PhpMyAdmin for example? Does it return the full data?

It sounds like quotes weren’t properly escaped during the inserting of the data. Did you use mysql_real_escape_string()? Also, are you outputting to a webbrowser or to the PHP CLI? If to the webbrowser, try escaping the data using htmlentities() before echoing/printing.

Sponsor our Newsletter | Privacy Policy | Terms of Service