Generating RSS feeds with PHP

[Rollo_Tamasi]

hi guys i'm wondering if the following is possible? i want to be able to generate an rss feed from my php pages.

i have a mysql database with fields for title, author, url & message,
i would like to have the content that is stored in the db under each of those fields to appear in a xml page which is rss compliant thru PHP.

i have google for the answer but rss seems to be too much of a generic search term these days. I would appricate it very much is someone knows of a tutorial or a script that can do this for me. Thanks

[bpat1434]

1.) Do you know proper RSS/XML standards? If so, then it's easy
2.) Do your query, then output the XML with the proper header

So something like:

<?php
$conn = mysql_connect(); // Insert connection info
mysql_select_db(); // Insert database info

$query = "SELECT * FROM `table` ORDER BY title ASC";
$result = mysql_query($query);

$output = ''; // XML header line

while($row = mysql_fetch_array($result))
{
  $output .= '<entry title="'.$row['title'].'">
      <author>'.$row['author'].'</author>
      <message>'.$row['message'].'</message>
      <url>'.$row['url'].'</url>
    </entry>';
}

$output .= ''; // Closing XML stuff

header('Content-Type: application/rss+xml');
print $output;

Using that as a basis, it's just a matter of formatting the XML correctly.....