Hi Kirupians
I have a Mysql database which has data with double quotation marks.
I retreive the data using PHP in XML format (doesn’t matter if its AS2 or AS3) using the PHP functions below
$result = mysql_query(“SELECT productid, www, FROM products WHERE product LIKE '%”.$key."%’");
echo ‘<?xml version=“1.0” encoding=“UTF-8”?>’;
echo ‘<datapacket>’;
while($row=mysql_fetch_array($result)){
*** $line = ‘<row productid="’.$row[productid].’" www="’.$row[www].’" />’; ***
echo $line;
if the field www contains qutation marks ie:“I love you” nothing is returned because
$line = ‘<row productid="’.$row[productid].’" www="’.$row[www].’" />' is violated with extra quotation marks.
Therefore I have to suppress the quotation marks.
How can I do it?
I tried [COLOR=red]str_replace[/COLOR] command by adding an Escape character[COLOR=red] [SIZE=4][/SIZE][/COLOR] but no luck
$row[www] = str_replace(’"’, ’ " ', $row[www]);
Thanks
Hagop
