<?php
include "db.php";
mysql_select_db ("news",$connection);
mysql_query("SET NAMES UTF8");

$school=$_GET['school'];
$selezionedati = "SELECT * FROM posts where cat_id='$school' ORDER BY ID DESC LIMIT 20" ;
$query = mysql_query ($selezionedati);


header("Content-Type: text/html; charset=utf-8");

echo (" <rss version=\"2.0\" > ");
echo (" <channel> ");
echo (" <title> ข่าวโรงเรียน </title>") ;
echo (" <link> </link>") ;
echo (" <description> ศูนย์ข่าวโรงเรียนในสังกัดสำนักงานเขตพื้นที่การศึกษามัธยมศึกษาราชบุรี</description>");
echo (" <copyright> Copyright 2015 </copyright>");
echo " <docs> http://espanici </docs>";
echo " <managingEditor> espanici ( emanuele ) </managingEditor>";
echo " <webMaster> espanici.com ( emanuele ) </webMaster>";

while ($array = mysql_fetch_array ($query )) {
extract ($array);
$dt=strip_tags($description);
$text1=preg_replace("/&#?[a-z0-9]{2,8};/i","",$dt);
echo "<item><title> $title </title>";
echo "<link> $code_url";
echo "story.php?id=$id </link>";
echo "<description><![CDATA[<img src=\"$image\" width=\"250\" height=\"170\" />]]> $text1</description>
</item> ";
}
echo "</channel></rss>";
?>