Location: PHPKode > projects > Alex! TestBlog > alextestblog02/alex-rss.php
<?php

include("alex-admin/alexconfig.php");


$resultt = mysql_query("SELECT * FROM alex_options");

while($roww = mysql_fetch_array($resultt))
  {
 $titlee = $roww['title'];
 $descriptionee = $roww['description'];
  }




echo '<?xml version="1.0" ?'.'>'; ?>
<rss version="0.92">
<channel>
<?php

echo "<title>" . $titlee . "</title>
	<link>" . $alexsiteurl . "</link>
	<description>" . $descriptionee . "</description>
	<lastBuildDate>" . date('Y-m-d') . "</lastBuildDate>
	<docs>http://backend.userland.com/rss092</docs>
	<language></language>";

?>
	
	
<?php

$result = mysql_query("SELECT * FROM alex_posts ORDER BY id LIMIT 0,18");

while($row = mysql_fetch_array($result))
  {
  echo "<item>";
  echo "<title>" . $row['posttitle'] . "</title>";
echo "<link>index.php?id=" . $row['id'] . "</link>";
echo "<description>" . $row['pagecontent'] . "</description>";
echo "</item>";
  }

mysql_close($con);
?>

</channel>
</rss>
Return current item: Alex! TestBlog