[RESOLVED] Having trouble with Dynamic RSS Feed created with PHP

[mbrown174]

Hello,
Still a bit of a newb in PHP and was hoping someone could steer me in the right direction. Below is code I use to create my RSS feed. I currently have it showing just one record, I cant seem to get it to display more than one and would like to know a way I could get say five records displaying on the feed. I was hoping it could be something simple - like the use of an increment? Thanks for any help!

<?php require_once('Connections/Forum.php');
mysql_select_db($database_Forum, $Forum);
$query_Forum = "SELECT * FROM `forum`";
$maxRows_Forum = 3;
$pageNum_Forum = 0;
$startRow_Forum = $pageNum_Forum * $maxRows_Forum;
$query_limit_Forum = sprintf("%s LIMIT %d, %d", $query_Forum, $startRow_Forum, $maxRows_Forum);
$Forum = mysql_query($query_limit_Forum,$Forum) or die(mysql_error());
$row_Forum = mysql_fetch_assoc($Forum);
$title = $row_Forum['Title'];
header('Content-type: application/rss+xml; charset=utf-8');
echo "<?xml version=\"1.0\" ?>"; 
echo "
<rss version=\"2.0\">
<channel>
<title>North Liverpool Academy Intranet News</title>
<description>Tutorial and discussion area for Students</description>
<link>http://www.northliverpoolacademy.co.uk</link>";
echo "<item>";
echo "<title>".$row_Forum['Title']."</title>";
echo "<description>".$row_Forum['Post']."</description>";
echo "<link>'test'</link>";
echo "<pubDate>".$row_Forum['TimeofPost']."</pubDate>";
echo "</item>";
echo "</channel></rss>";
?>

[kkobashi]

You just need to loop through on the query result set...
Create a function so you can reuse it like so:

<?php
function ForumsRss($dbHost, $dbUser, $dbPass, $dbName, $maxItems) {
  $dbId = mysql_connect($dbHost, $dbUser, $dbPass))
  if (!$dbId)
     die("Could not connect to database");
  if (!mysql_select_db($dbName, $dbId);
     die("Could not select database");

  $query = "SELECT * from Forum LIMIT 0, {$maxItems}";
  $result = mysql_query($query, $dbId) or die(mysql_error());
  $numRecs = mysql_num_rows($result);

  header('Content-type: application/rss+xml; charset=utf-8');
  echo "<?xml version=\"1.0\" ?>"; 
  echo "<rss version=\"2.0\">
  echo "<channel>";
  echo "<title>North Liverpool Academy Intranet News</title>";
  echo "<description>Tutorial and discussion area for Students</description>";
  echo "<link>http://www.northliverpoolacademy.co.uk</link>";

  // Please check this...
  // Format must conform to RSS 2.0 Spec
  $currentDateTime = date("D, M j G:i:s T");

  if ($numRecs == 0) {
    echo "<item>";
    echo "<title>Empty RSS Channel List</title>";
    echo "<description>There are no items</description>";
    echo "<link>http://www.yoursite.com</link>";
    echo "<pubDate>{$currentDateTime}</pubDate>";
    echo "</item>";
  }
  else {
     while($row = mysql_fetch_assoc($result)) {
       echo "<item>";
       echo "<title>{$row['Title']}</title>";
       echo "<description>{$row['Post']}</description>";
       echo "<link>{$row['Link']}</link>";
       echo "<pubDate>{$row['TimeofPost']}</pubDate>";
       echo "</item>";
     }
  }
  echo "</channel>";
  echo "</rss>";
  mysql_close($dbId);
}
?>

Then you can call the function like this:

ForumsRss("localhost", "theuser", "password", "mydatabase", 3);

Cleaner? Easy to read and understand?

[mbrown174]

Having a look through the code now...