$tempCompanyEmail = $row['value']; // Get SystemURL $query = "Select * FROM tblconfiguration where setting='SystemURL' limit 0,1"; $result = mysql_query($query) or die("tblconfiguration: SystemURL not found"); if (mysql_num_rows($result) == 0) { die("tblconfiguration: SystemURL not found"); } $row = mysql_fetch_assoc($result); $tempSystemURL = $row['value']; ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////// $rss = new rss('utf-8'); $rss->channel($tempCompanyName . ' Tickets', $tempSystemURL, $tempCompanyName . ' Tickets'); $rss->language('en-us'); $rss->copyright('Copyright ' . $tempCompanyName); $rss->managingEditor($tempCompanyEmail); $rss->category('CategoryName'); $rss->startRSS(); $query = "Select * FROM tbltickets " . $tempSQL . " order by lastreply desc limit 0," . $constTicketsToDisplay; $result = mysql_query($query) or die("No Tickets Found"); if (mysql_num_rows($result) == 0) { die("No Tickets Found"); } while ($row = mysql_fetch_assoc($result)) { $rss->itemTitle("<![CDATA[" . $row['title'] . "]]>"); $rss->itemLink("<![CDATA[" . $tempSystemURL . "/admin/supporttickets.php?action=viewticket&id=" . $row['id'] . "]]>"); $rss->itemDescription("<![CDATA[" . $row['message'] . "]]>"); $rss->itemAuthor($row['name'] . " " . $row['email']); $rss->addItem(); } echo $rss->RSSdoneVar();