How does the RSS show up on the website?

[Soleiltan]

Greetings all,

Just bought it and so far...really like it; Developer.

http://www.sandrailsonly.curbstoners.com/index.php

How does the RSS show up on the website?

Here is my RSS code that I changed to make all children show up in feed.

<?php
/*
 * 68 Classifieds
 * 
 * All source code & content (c) Copyright 2006, 68 Classifieds
 * unless specifically noted otherwise.
 * 
 * @Author $Author: Eric $ (68 Classifieds)
 * @copyright 68 Classifieds
 * @link http://www.68classifieds.com
 * @version 3.1
 * @$Revision: 1.2 $
 * @Updated: $Date: 2006/06/21 12:45:41 $
 * @package 68 Classifieds
 *
 */
require_once('includes/init.php');
	//now setup the search query
	$count="";
	$sSQL="SELECT p.id, p.owner, p.title, p.featured, p.section, p.description, p.price, p.dateadded, p.expiration, p.pBold, p.pHighlighted, u.state, u.city, u.country, u.username FROM ".PREFIX."products AS p LEFT JOIN ".PREFIX."users AS u ON p.owner = u.id WHERE p.expiration > NOW() AND p.display = 'Y' ";
	//now get the search fields
	if (isset($_REQUEST['type'])&& $_REQUEST['type']<>"")
	{
		$arr_childs = array((int)$_REQUEST['type']);
		get_ids($arr_childs);
		$sSQL .= ( empty($arr_childs) ) ? '': " AND p.section IN (". implode(', '
	}
	if (isset($_REQUEST['state'])&& $_REQUEST['state']<>"")
	{
		$sSQL .= " AND u.state = '".mysql_real_escape_string($_REQUEST['state'])."'";
	}
	if (isset($_REQUEST['city'])&& $_REQUEST['city']<>"")
	{
		$sSQL .= " AND u.city = '".mysql_real_escape_string($_REQUEST['city'])."'";
	}
	if (isset($_REQUEST['country'])&& $_REQUEST['country']<>"")
	{
		$sSQL .= " AND u.country = '".mysql_real_escape_string($_REQUEST['country'])."'";
	}
	if (isset($_REQUEST['owner'])&& $_REQUEST['owner']<>"")
	{
		$sSQL .= " AND p.owner = ".(int)$_REQUEST['owner'];
	}
	if (isset($_REQUEST['searchtext'])&& $_REQUEST['searchtext']<>"")
	{
		$searchtext=trim(mysql_real_escape_string($_REQUEST['searchtext']));
		$sSQL .= " AND (p.title LIKE '%".$searchtext."%' OR p.description LIKE '%".$searchtext."%')";
	}
	//search price//
	$minprice=(int)trim(@$_REQUEST['minprice']);
	$maxprice=(int)trim(@$_REQUEST['maxprice']);
	if($minprice == "")
		$minprice=0;
	if($maxprice == "")
		$maxprice=9999999;
	$sSQL .= " AND p.price BETWEEN ". $minprice ." AND ". $maxprice;
	//now group by
	$sSQL .= " GROUP BY p.id, p.owner, p.title, p.featured, p.section, p.description, p.price, p.dateadded, p.expiration ,u.state, u.city, u.country";
	if($count>0)
	{
		$sSQL.=" HAVING count(sValue) = ".$count;
	}
	$sSQL .= " ORDER BY p.dateadded DESC";
	//now limit
	if(isset($_GET['limit']) && $_GET['limit']<>"")
	{
		$sSQL .= " LIMIT ". (int)$_GET['limit'];
	}
	else
	{
		$sSQL .= " LIMIT 15";
	}
	//buld array of listings
	$ads = array();
	$result = $db->query($sSQL);
	while ($rs=$result->fetch()) 
	{ 
		$ads[] = $rs;
	}
	// set XML type and nocache headers
	header('Content-Type: text/xml');
	header('Expires: ' . gmdate('D, d M Y H:i:s') . ' GMT');
	header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
	header('Pragma: public');
	// print out the page header
	echo '<rss version="0.92">' . "\r\n";
	echo "<channel>\r\n";
	echo "\t<title>" . htmlspecialchars($title) . "</title>\r\n";
	echo "\t<link>".URL."</link>\r\n";
	echo "\t<description>" . htmlspecialchars(DESCRIPTION). "</description>\r\n";
	echo "\t<docs>http://backend.userland.com/rss092</docs>\r\n";
	echo "\t<language>en</language>\r\n";
	// list returned threads
	if (!empty($ads))
	{
		foreach ($ads AS $listing)
		{
			echo "\t\t\t<item>\r\n";
			echo "\t\t\t\t<link>". URL ."/viewlisting.php?view=".$listing['id']."</link>\r\n";
			echo "\t\t\t\t<title>" . $listing[title] . "</title>\r\n";
			echo "\t\t\t\t<author>" . $listing[username] . "</author>\r\n";
			echo "\t\t\t\t<date>" . $listing['dateadded'] . "</date>\r\n";
			echo "\t\t\t</item>\r\n";
		}
	}
	//close the feed
	echo "</channel>\r\n";
	echo "</rss>";
?>

Specifics please....I just don't see anyway to capture the feed from my Mozilla brower....? I have saved other feeds by clicking on an RSS icon.

[Lhotch]

RSS feeds by default arent made to show up on a website. They are meant to be viewed with an RSS reader.

[cheesegrits]

I think he's asking where the feed icon is to allow a user to subscribe to the feed.

-- hugh

[Eric Barnes]

Originally Posted by cheesegrits

I think he's asking where the feed icon is to allow a user to subscribe to the feed.

In that case you could add this line to the head of the layout template:
<link rel="alternate" type="application/rss+xml" title="RSS Feed" href="http://yoursite.com/external.php" />

[Soleiltan]

Excellent...working like a charm....

[Soleiltan]

Except that now...I am getting this

This feed contains code errors.
Go back to the previous page.

More information

XML document must have a top level element.
Line: 0 Character: 0

[Eric Barnes]

Can you try and upload an original external.php file. Maybe it got corrupt some how.

[Soleiltan]

That seemed to make the RSS function, but perhaps the error is happening when I add the code to make the child categories part of the feed. I entered it from another's post. See above.

Here it is exactly....

{
		$arr_childs = array((int)$_REQUEST['type']);
		get_ids($arr_childs);
		$sSQL .= ( empty($arr_childs) ) ? '': " AND p.section IN (". implode(', '
	}

Thanks...

[Lhotch]

Originally Posted by Soleiltan

That seemed to make the RSS function, but perhaps the error is happening when I add the code to make the child categories part of the feed. I entered it from another's post. See above.

Here it is exactly....

{
		$arr_childs = array((int)$_REQUEST['type']);
		get_ids($arr_childs);
		$sSQL .= ( empty($arr_childs) ) ? '': " AND p.section IN (". implode(', '
	}

Thanks...

In the above code you dont have a closing bracket on the implode statement. Even if you did, im not sure it would work. Can you provide a link where you got the code changes from?

[Soleiltan]

Here is the link...

Rss by garysmith