RSS Feed - not updating

[chrislive]

Hi everyone,

I have written this quick RSS script however when I view from a browser I get all the items, however from something like RSSOwl it will only show 1 or 2 or them. Is this normal behaviour? actually I dont know much about RSS but customer wants it for their website so I need to put it in there.

When i add I can see that it find 6 articles but only a couple are shown. Is this normal for if the news is actually old or had been viewed previously?

Im not sure if its a problem with my code but here it is anyways.

<?php header("Content-type: text/xml"); ?>
<?php echo '<?xml version="1.0" encoding="iso-8859-1"?>'; ?>
<rss version="0.9.1">
  <channel>
    <item>
      <title>RSS Feed</title>
      <link>[url]http://www.url.net[/url]</link>
      <description>Some description about the site</description>
    </item>
  </channel>

<?php
  require("incs/includes.php");
  require("incs/sqlconnect.php");
  include("incs/classes/classes.php");

  $query = "SELECT * from ws_news ORDER BY 'date' DESC";
  $result = @mysql_query ($query);

  while ($row = mysql_fetch_array($result, MYSQL_NUM)){
    $id = $row[0];
    $date = $row[1];
    $title = $row[2];
    $details = $row[3];
    //$details = HTMLConvert($details, 'revert_short');
?>

  <item>
    <title><?php echo "$title"; ?></title>
    <link><?php echo "$sitename"; ?></link>
    <description><?php echo "$details"; ?></description>
  </item>

 <?php
    }
 ?>

</rss>

[chrislive]

I found the problem my channel tag was not at the end of the feed as it should be. I have modified the code accordingly and have gotten it working with images also in the description.

I hope you all can find this useful 🙂

filename: rss.php

<?php 
header("Content-type: text/xml");
echo '<?xml version="1.0" encoding="iso-8859-1"?>';
?>

<?php
// Lets get our includes with details such as $page_title & $sitename
// Alternatively enable these:
// $page_title = "Page Title";
// $sitename = "http://www.domain.com";
  require("incs/includes.php");

// Lets call our DB class
  require("incs/sqlconnect.php");
?>

<rss version="2.0">
  <channel>
     <title><?php echo "$page_title"; ?> RSS Feed</title>
     <link><?php echo "$sitename"; ?></link>
     <description>Welcome to the RSS Feed for <?php echo "$page_title"; ?> where you can stay up to date with everything that is going on through your RSS Reader.</description>
     <pubDate>Mon, 06 Jun 2005 00:00:01 GMT</pubDate>
     <ttl>60</ttl>

<?php

  $query = "SELECT * from ws_news ORDER BY 'date' DESC";
  $result = @mysql_query ($query);

  while ($row = mysql_fetch_array($result, MYSQL_NUM)){
    $id = $row[0];
    $date = $row[1];
    // My Date is in YYYY-MM-DD format so I must adjust to suit the RSS.
    $date = date("D, d M Y",strtotime($date));
    $formatted_date = "$date 00:00:01 GMT";
    $title = $row[2];
    $details = $row[3];
    $image = $row[4];
?>

  <item>
    <title><?php echo "$title"; ?></title>
    <link><?php echo "$sitename/ws_news.php?rssid=$id"; ?></link>
    <pubDate><?php echo "$formatted_date"; ?></pubDate>
    <description>
      <?php
        // If we have an image stored in the DB we use this to display because using " will cause problems
        if($image != ""){
          $imagefile = "$sitename/content_images/$image";
          echo '&lt;img src=&quot;'; echo "$imagefile"; echo '&quot; align=&quot;left&quot; width=&quot;250&quot;&gt;';
        }
      ?>

  <?php echo "$details"; ?>
</description>
  </item>

 <?php
    }
 ?>

<webMaster>[e-mail]</webMaster>
<generator>Generator</generator>
<copyright>Copyright: (C) 2005 Company</copyright>
  </channel>
</rss>