<?php
$db_user = "root"; // db username
$db_pass = ""; // db password
$db_host = "localhost"; // db host
$db = ""; // db
$adminmail = "bankera19@abv.gb"; // administrator e-mail
$websitetitle = "ViP Music!!! - Намери своята любима песен."; // title of your website
$website = "http://vip-music.cogia.net/";
$rssdescr = "Сайта за музика на Гр. Койнаре :)";
$year = "2010";
?>
<?php
echo ("<?xml version=\"1.0\" encoding=\"windows-1251\"?>\n");
?>
<rss version="2.0">
<channel>
<title>ViP Music!!! - Намери своята любима песен.</title>
<link><? echo "$website";?></link>
<description><? echo "$rssdescr";?></description>
<copyright>(c) <? echo "$year"; ?> ViP Music!!! - Намери своята любима песен.</copyright>
<ttl>60</ttl>
<language>bg-BG</language>
<webMaster><? echo "$adminmail";?></webMaster>
<?php
mysql_connect($db_host,$db_user,$db_pass);
mysql_select_db($db) or die( "Unable to select database");
$result = mysql_query ("SELECT * FROM songs ORDER BY id DESC LIMIT 25") or die (mysql_error());
while ($row = mysql_fetch_array ($result)) {
echo "<item>
<title>";
echo "$row[name]";
echo "</title>";
echo "<link>";
echo "http://vip-music.cogia.net/index.php?m=play&id=$row[id]";
echo "</link>";
echo "<description><![CDATA[ ";
echo "$row[name]";
echo "]]></description>";
echo "
</item>";
}
mysql_free_result ($result);
?>
</channel>
</rss>