PDA

View Full Version : help in "Pausing RSS scroller"



feri
06-14-2006, 12:38 PM
hi,
my rss is this: http://www.blogsaz.com/rss_all.php
but this script doesnt accept mine.
plz help me

feri
06-14-2006, 12:49 PM
here the codes i used:


<?
include "mysqlcon.php";
include "functions.php";

header("Content-Type: text/xml");
header("Pragma: no-cache");
echo "<?xml version=\"1.0\" encoding=\"utf-8\"?>
<rss version=\"2.0\">
<channel>
<title>Blovi.com</title>
<description>Free Blogging, Podcasting, Moblogging and more!</description>
<link>http://www.blovi.com</link>
<language>en-us</language>
<generator>Blovi.com</generator>
";

$query = "SELECT bhost_entries.e_id,bhost_entries.title,bhost_entries.contents,bhost_users.username,bhost_users.display_name,bhost_weblogs.weblog,bhost_entries.date FROM bhost_entries,bhost_users,bhost_weblogs WHERE bhost_entries.author_u_id = bhost_users.u_id AND bhost_entries.w_id = bhost_weblogs.w_id AND bhost_weblogs.rss_on != 0 AND bhost_entries.privacy='3' AND bhost_entries.draft ='0' ORDER BY bhost_entries.e_id DESC LIMIT 20";
$result = mysql_query($query);
while(list($id,$title,$contents,$username,$user,$weblog,$date) = mysql_fetch_array($result)){
$basepath2 = "http://blovi.com/$weblog/$id";
$content = str_replace("'", "'", $contents);
$title = str_replace("'", "'", $title);
/* if($entry[rss_html] == "0") {
$content = strip_tags($content);
$title = strip_tags($title);
}*/
$content = htmlspecialchars($content);
$title = htmlspecialchars($title);
$date = cdate("n/j/Y",$date);
echo "
<item>
<title>$title</title>
<description>$content</description>
<link>$basepath2</link>
<pubDate>$date</pubDate>
<author>$weblog</author>
</item>
";
}
echo "
</channel>
</rss>";







?>