= (CURDATE()-1))";
// display XML information
// this must be called before any output
header("Content-Type: text/xml; charset=UTF-8");
echo"
".SITENAME."
http://".$site."
New Listings Today on ".SITENAME."en-us".$today."".$today."";
$result=mysql_query($query1);
$num=mysql_numrows($result);
if($num<1){echo" ";} else {
while ($row = mysql_fetch_assoc($result)) {
$listingid=$row['listing_id'];
$title=htmlspecialchars($row['title']);
$description=htmlspecialchars($row['description']);
$listdate=$row['listdate'];
$category=htmlspecialchars($row['parent']);
$cat_id=$row['category_id'];
$description=rsstrunc($description,100);
// display an item
echo"".$category.": ".$title."
http://".$site."/showad.php?listingid=".$listingid."&cat=".$cat_id."
".$description."".$listdate."http://".$site."/showad.php?listingid=".$listingid."&cat=".$cat_id."";
}
echo"
";}
?>