[FONT=Verdana]Hi Guys, I’m having trouble with illegal special characters when I export XML from PHP. I know it’s a case of replacing for example ‘[/FONT][FONT=Verdana]<’ with ‘<’ but I’m having trouble placing it within my code. Cant someone help? Code is below
<?php require_once(’…/Connections/connProperty.php’); ?>
<?php[/FONT]
[FONT=Verdana]
// Load the XML classes
require_once(’…/includes/xml/XML.php’);[/FONT]
[FONT=Verdana]mysql_select_db($database_connProperty, $connProperty);
$query_rsProperty = “SELECT forsale, tagline, p_address, p_locality, bullet, p_desc, footer, CONCAT(img_path1,p_img1,img_path2) AS p_img1, p_img2, p_img3 FROM corryandstewart_print”;
$rsProperty = mysql_query($query_rsProperty, $connProperty) or die(mysql_error());
$row_rsProperty = mysql_fetch_assoc($rsProperty);
$totalRows_rsProperty = mysql_num_rows($rsProperty);[/FONT]
[FONT=Verdana]
// Begin XMLExport rsProperty
$xmlExport_rsProperty = new XML_Export();
$xmlExport_rsProperty->setRecordset($rsProperty);
$xmlExport_rsProperty->addColumn(“forsale”, “STRING_TYPE”, “forsale”);
$xmlExport_rsProperty->addColumn(“tagline”, “STRING_TYPE”, “tagline”);
$xmlExport_rsProperty->addColumn(“p_address”, “STRING_TYPE”, “address”);
$xmlExport_rsProperty->addColumn(“p_locality”, “STRING_TYPE”, “locality”);
$xmlExport_rsProperty->addColumn(“bullet”, “STRING_TYPE”, “bullet”);
$xmlExport_rsProperty->addColumn(“p_desc”, “STRING_TYPE”, “desc”);
$xmlExport_rsProperty->addColumn(“footer”, “STRING_TYPE”, “footer”);
$xmlExport_rsProperty->addColumn(“p_img1”, “STRING_TYPE”, “img1”);
$xmlExport_rsProperty->addColumn(“p_img2”, “STRING_TYPE”, “img2”);
$xmlExport_rsProperty->addColumn(“p_img3”, “STRING_TYPE”, “img3”);
$xmlExport_rsProperty->setFilename(“property.xml”);
$xmlExport_rsProperty->setMaxRecords(“8”);
$xmlExport_rsProperty->setDBEncoding(“UTF-8”);
$xmlExport_rsProperty->setXMLEncoding(“UTF-8”);
$xmlExport_rsProperty->setXMLFormat(“NODES”);
$xmlExport_rsProperty->Execute(“VALUE”, “1”);
// End XMLExport rsProperty
?>[/FONT][FONT=Verdana][/FONT]
