Grrilla said:I don't know if this is pertinent to the discussion, but, coincidentally, this morning I was reading about RSS Feed Creators in PC Magazine and their top rated one was: Feeder1.1 www.reinventedsoftware.com/feeder followed by www.feederforall.com and NewzAlertComposer www.castlesoftware.biz.
Grrilla said:I don't know if this is pertinent to the discussion, but, coincidentally, this morning I was reading about RSS Feed Creators in PC Magazine and their top rated one was: Feeder1.1 www.reinventedsoftware.com/feeder followed by www.feederforall.com and NewzAlertComposer www.castlesoftware.biz.
Grrilla said:Tx for the correction. I mistyped as I was pulling the info from PC mag.
The double post is totally acceptable, as I often need the extra reminder.:hehe:
Mayur said:I want to use XML but Im stuck with PHP cus my feed gets updated automatically off my news srcipt which runs off MySQL.
<?php
header ("Content-type: text/xml");
echo ("<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n");
?>
<rss version='2.0'>
<channel>
<title>Biggie Smalls | The Notorious BIG</title>
<description>News for the infamous rapper, The Notorious BIG</description>
<link>http://biggiesmalls.info/news//rss.php</link>
<language>en-us</language>
<?php
$db_host = "localhost";
$db_name = "biggie_news"; //database name
$db_user = "biggie_news"; //database user
$db_pass = "*****"; //user password
$db_connection = @mysql_pconnect($db_host,$db_user,$db_pass) or die("Sorry, cannot connect to database.");
@mysql_select_db($db_name,$db_connection) or die(dbdown());
$result = mysql_query ("SELECT * FROM `news` ORDER BY `id` DESC LIMIT 0,10 ") or die (mysql_error());
while ($row = mysql_fetch_array ($result)) {
$desc = $row[3];
$desc = str_replace("\n","<br />",$desc);
echo (" <item>
<title>");
echo $row[1];
echo ("</title>
<description>");
echo $desc; //content you want the person to read
echo ("</description>
<link>http://yoursite.com/index.php?article=");
echo $row[0];
echo ("</link>
</item>\n\n");
}
mysql_free_result ($result);
?>
</channel>
</rss>
Mayur said:Here is my feed.
http://biggiesmalls.info/news/rss.php
Here is the code to it. If you can tell me how to make it in xml format then Ill send some NP$.
Code:<?php header ("Content-type: text/xml"); echo ("<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n"); ?> <rss version='2.0'> <channel> <title>Biggie Smalls | The Notorious BIG</title> <description>News for the infamous rapper, The Notorious BIG</description> <link>http://biggiesmalls.info/news//rss.php</link> <language>en-us</language> <?php $db_host = "localhost"; $db_name = "biggie_news"; //database name $db_user = "biggie_news"; //database user $db_pass = "*****"; //user password $db_connection = @mysql_pconnect($db_host,$db_user,$db_pass) or die("Sorry, cannot connect to database."); @mysql_select_db($db_name,$db_connection) or die(dbdown()); $result = mysql_query ("SELECT * FROM `news` ORDER BY `id` DESC LIMIT 0,10 ") or die (mysql_error()); while ($row = mysql_fetch_array ($result)) { $desc = $row[3]; $desc = str_replace("\n","<br />",$desc); echo (" <item> <title>"); echo $row[1]; echo ("</title> <description>"); echo $desc; //content you want the person to read echo ("</description> <link>http://yoursite.com/index.php?article="); echo $row[0]; echo ("</link> </item>\n\n"); } mysql_free_result ($result); ?> </channel> </rss>



