sql calls do weird things with this character : "
<p>I have a form that auto calls information for products, it uses autocomplete to pull the product description when someone puts in the product name.  When the form calls the data, sample data may look like this :</p>

<p>Samsung 40" HDTV Television</p>

<p>After the form is saved, and reloaded, the data loaded looks like this :</p>

<p>Samsung 40</p>

<p>Is there a way to mass edit my product descriptions to replace " with inch, or to make this not happen</p>

<p>Using SQL</p>

<p>Code sample of insert :</p>

<pre><code>foreach (blabla)
$productName = mysqli_real_escape_string( $this-&gt;_con, trim( $invoice_detail['productName'] ) );
$query = "INSERT INTO invoice (`productName`) VALUES ('$productName')
mysqli_query($this-&gt;_con, $query);
</code></pre>

<p>Code sample of retrieve :</p>

<pre><code>&lt;td&gt;&lt;input value="&lt;?php echo isset($item['productName']) ? $item['productName']: ''; ?&gt;" type="text" data-type="productName" name="data[InvoiceDetail][&lt;?php echo $key;?&gt;][productName]" id="itemName_&lt;?php echo $key+1?&gt;"&gt;&lt;/td&gt;
</code></pre>