This is the code it runs as I want it to but the output 'name' from the table in database always shows i.e. £101 instead of £101 what do I need to correct in the code shown?
<?php
header('Content-type: text/xml; charset=UTF-8');
$host = "host";
$user = "testing";
$pass = "abcdefghikans";
$database = "test";
$linkID = mysql_connect($host, $user, $pass) or die("Could not connect to host.");
mysql_select_db($database, $linkID) or die("Could not find database.");
$rss = '<?xml version="1.0" encoding="UTF-8"?>';
$rss .= '<rss version="2.0">';
$rss .= '<channel>';
$rss .= '<title>Competition Feed</title>';
$numStart = gmmktime(0, 0, 0, date('m')-1, 1, date('Y'));
$numEnd = gmmktime(0, 0, 0, date('m'), 1, date('Y'))-1;
$sql = "SELECT name FROM table WHERE active = '0' AND closedate >= '$numStart' AND closedate <= '$numEnd' AND value >=100 ORDER BY value DESC";
$query = mysql_query($sql, $linkID) or die("Data not found.");
while ($row = mysql_fetch_array($query)) {
$rss .= '<item>';
$rss .= '<description>'.$row['name'].'</description>';
$rss .= '</item>';
}
$rss .= '</channel>';
$rss .= '</rss>';
echo $rss;
?>
