Insert Into - need help

PHP
1

Hi There,

I purchased a script to do a one off transfer of data between two eCommerce solutions. It is all working fine except for the description for the products.
The original looks something like this:

<div style="text-align: center"><span

(snippet)
but after importing the resulting html looks like this

<div style=&quot;text-align: center&quot;><span

The line that does this has the following in front of the descriptions field “insert into”
mysql_real_escape_string(htmlspecialchars($prs[‘products_description’]))

I’ve taken it out, but then I get errors when it hits a single quote somewhere in the html!
Any thoughts on how to get around this ?
TIA, Dave

2

Hi Dave.

Change that line to…


mysql_real_escape_string($prs['products_description'])

and you should be OK. :slight_smile:

Anthony.

3

Yes, worked a treat!
Thanks so much !
Dave