<?php
header("Refresh: 2;");
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = '02071987';
$dbname = 'ProvoleasDB';
mysql_connect($dbhost,$dbuser,$dbpass) or die ("I could not connect!");
mysql_select_db($dbname) or die (mysql_error());
header("Content-type: text/xml");
echo '<?xml version=\'1.0\' encoding=\'UTF-8\'?>';
echo '
<rss version=\'2.0\'> ';
echo '
<channel>
<title></title>
<description></description>
<link></link>';
$data = mysql_query('SELECT * FROM UploadItem ORDER BY IID DESC LIMIT 10');
while($row = mysql_fetch_array($data))
{
echo '
<item>
<title>'.$row['FileName'].'</title>
<link>localhost/items.php?iid='.$row['IID'].'</link>
<description>'.$row['IID'].'</description>
<guid>http://localhost/items.php?iid='.$row['IID'].'</guid>
</item>';
}
echo '
</channel>
</rss>';
?>
<html>
<head>
</head>
<body>
</body>
</html>
θελω γινεται refresh σ αυτο τ αρχειο καθε μια ωρα και δεν ξερω πως =/
