I modified this code a little to better learn PHP (I\'m a PHP newbie). Since I currently have each datafeed source in a separate table in my database, I can add a ?x=tablename to pull a feed from that table instead of from the database in general. The description area is modified to work with CSV files from Shareasale, but you could just replace the table names with those from your network.

<?php
// Some RSS readers don\'t like certain characters in the text so this function will replace them with HTML entities
function escape_upper_chars($text) {
// 32-90, 97-122
for ($x = 0; $x < strlen($text); $x++) {
$w = $text{$x};
if ((ord($w) < 32) || ((ord($w) > 90) && (ord($w) < 97)) || (ord($w) > 122)) {
$q .= \'&#\'.ord($w).\';\';
} else {
$q .= $w;
}
}
return $q;
}

$x = mysql_real_escape_string($_GET[x]);
if(!$x) { $x = \'exampletablename\'; }

header(\"Content-type: text/xml\");

// Send the header data
echo \"<?xml version=\\"1.0\\"?><!DOCTYPE rss SYSTEM \\"http://my.netscape.com/publish/formats/rss-0.91.dtd\\">
<rss version=\\"0.91\\">

RSS Feedenhttp://www.website.com RSS Feed Description\\n\"; // Force int data type on $limit to prevent SQL injection attacks $limit = (int)$_GET[\'limit\']; if (($limit < 1) || ($limit > 50)) { $limit = 20; } // Set the default number of results // Query the database (make sure you have included the necessary commands to connect to a MySQL server) $query = \"SELECT Name,Merchant,Link,BigImage,Price,Category,SubCategory,Description,Manufacturer,MerchantCategory,MerchantSubcategory,Num FROM $x ORDER BY Num DESC LIMIT $limit\"; $s = mysql_query($query); // Change the variables here according to your query above while (list($name,$merchant,$link,$bigimage,$price,$category,$subcategory,$description,$manufacturer,$merchantcategory,$merchantsubcategory,$num) = mysql_fetch_row($s)) { $title = escape_upper_chars($name); $description = escape_upper_chars($description); // Customize the data sent to the RSS reader. You should pass text grabbed from the database through escape_upper_chars() echo \"\\n\"; // Begin a new item echo \"$title\\n\"; // Send the title echo \"$link\\n\"; // Send link to the item echo \"<a href=\'$link\'><IMG SRC=\'$bigimage\' alt=\'$title\' align=\'left\' border=\'o\' hspace=\'10px\'></a> $title<br>$description $$price<p>$category - $subcategory - $merchantcategory - $merchantsubcategory From $merchant $manufacturer\\n\"; // Send description echo \"\\n\"; //End the item } echo \"\\n\"; // Close the RSS channel ?>