Файл: rss.php
Строк: 33
<?php
error_reporting(E_ALL | E_STRICT) ;
ini_set('display_errors', 'On');
include "inc/bd.php";
header("content-type: application/rss+xml");
echo '<?xml version="1.0" encoding="cp1251"?>
<rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/">
<channel>
<title>Лоты на бирже Kupisayt.ru</title>
<link>http://www.kupisayt.ru/</link>
<description>RSS лента с последними опубликованными лотами.</description>
<language>ru-ru</language>';
$query = mysql_query("SELECT * FROM sites ORDER BY `id` DESC LIMIT 10", $db);
if(mysql_num_rows($query) > 0) {
while($site = mysql_fetch_array($query)) {
$query2 = mysql_query("SELECT `cat_name` FROM cat WHERE cat_id = '$site[cat]'", $db);
$site2 = mysql_fetch_array($query2);
printf("
<item>
<title>%s</title>
<link>http://www.kupisayt.ru/view/%s/</link>
<description>%s</description>
<category>%s</category>
</item>
", $site['title'],$site['id'],$site['disc'],$site2['cat_name']);
}
}
echo "</channel>";
echo "</rss>";
?>