< ?xml version="1.0"?>

Virtuosi Media
http://www.virtuosimedia.com
A feed for articles on web development
en-us
2008 Virtuosi Media
jane.doe@example.com (Jane Doe)
john.doe@example.com (John Doe)
Tue, 08 Jul 2008 22:31:45 EDT
Tue, 08 Jul 2008 22:31:45 EDT
Web Development
Virtuosi Media RSS Generator
http://www.rssboard.org/rss-specification
60

http://www.virtuosimedia.com/images/logo_fancy.png
Virtuosi Media
http://www.virtuosimedia.com
95
133
A web development resource center

 
< ?php
 
//Connect to the database here
require_once(‘connect.php’);
 
//Create the SELECT statement and execute it
$query = "SELECT *, DATE_FORMAT(article_date, ‘%a, %d %b %Y %T PST’) AS article_pubdate FROM articles ORDER BY article_date LIMIT 5";
$result = mysql_query($query);
 
//Iterate over the rows to create each item
while ($row = mysql_fetch_array($result, MYSQL_ASSOC) {
echo ‘
‘.$row[‘article_title’].‘
‘.$row[‘article_url’].‘
‘.$row[‘article_text’].‘
‘.$row[‘article_author’].‘
‘.$row[‘article_category’].‘
‘.$row[‘article_pubdate’].‘
Virtuosi Media
 
}
 
?>
 

fonte: www.sastgroup.com