1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28

    //Let's update the RSS feed
    $feed = "<?xml version=\"1.0\" ?>\n";
    $feed .= "<rss version=\"2.0\">\n\n";
    $feed .= "<channel>\n";
    $feed .= "<title>http://johnsaxton.com</title>\n";
    $feed .= "<link>http://www.johnsaxton.com/</link>\n";
    $feed .= "<description>John Saxton's RSS feed</description>\n\n";
    
    $query = "SELECT * FROM blog_entries ORDER BY blog_timestamp DESC LIMIT 15";

    $result = q_select($dbh, $query);
    
    foreach($result as $item) {
        $date = date("D, d m Y H:i:s O", $item['blog_timestamp']);
        $feed .= "<item>\n";
        $feed .= "<title>".$item['blog_title']."</title>\n";
        $feed .= "<description>".$item['blog_firstpara']."</description>\n";
        $feed .= "<link>http://www.johnsaxton.com/blog/entry.php?id=".$item['blog_id']."</link>\n";
        $feed .= "<pubDate>".$date."</pubDate>\n";
        $feed .= "</item>\n\n";
    }
    
    $feed .= "</channel>\n\n";
    $feed .= "</rss>";

    $fp = fopen("/path/to/feed", 'w');
    fwrite($fp, $feed);
    fclose($fp);