Hi, I am using the code below to pull entries from a database depending to each user, but in Firefox is renders an empty page but all the output is in the source. and IE and safari, it breaks.
[url]http://garagesale.gozipline.com/rss,4.xml
[code=php]<?php
session_start();
header(“Content-Type: text/xml”);
include(“includes/connect.inc.php”);
if(!empty($_GET[‘userid’])){
$userid = $_GET[‘userid’];
}else{
header(“Location: /”);
die;
}
$output = NULL;
$emailqry = $db->query(“SELECT * FROM subscribers WHERE id = ‘{$userid}'”);
$emailrow = $db->fetchRow($emailqry, MDB_FETCHMODE_ASSOC);
$companyqry = $db->query(“SELECT * FROM company WHERE id = ‘{$emailrow[‘company_id’]}'”);
$companyrow = $db->fetchRow($emailqry, MDB_FETCHMODE_ASSOC);
?>
<rss version=”2.0″>
<channel>
<title><?php echo($companyrow[‘company_name’]); ?></title>
<description>Online Listings Finder</description>
<link>http://www.<?php echo($companyrow[‘company_address’]); ?></link>
<copyright><?php echo(date(‘Y’)); ?> <?php echo($companyrow[‘company_name’]); ?></copyright>
<?php
$feedqry = $db->query(“SELECT * FROM subscriptions WHERE rss=’true’ AND userid = ‘{$userid}'”);
$feednum = $db->numRows($feedqry);
while($feedrow = $db->fetchInto($feedqry, MDB_FETCHMODE_ASSOC)){
$datasql = stripslashes($feedrow[‘query’]);
$dataqry = $db->query($datasql);
$datanum = $db->numRows($dataqry);
while($datarow = $db->fetchInto($dataqry, MDB_FETCHMODE_ASSOC)){
$ad = strip_tags($datarow[‘ad’]);
$output .= “<item>”.”n”;
$output .= “<title>{$feedrow[‘title’]}</title>”.”n”;
$output .= “<address>{$datarow[‘address’]} ({$datarow[‘region’]})</address>”.”n”;
$output .= “<description>{$ad}</description>”.”n”;
$output .= “<link>$datanum</link>”.”n”;
$output .= “</item>”;
$output .= “nn”;
echo($output);
}
}
?>
</channel>
</rss>