Looks like it could work, however you'll need to be careful with the <?xml and ?> pair. Your PHP parser may expect there to be code between them. Instead consider something like...
<?php echo '<', '?xml version="1.0" encoding="UTF-8"?', '>'; ?> Phill On 16/07/06, Jer <[EMAIL PROTECTED]> wrote: > > I'm trying to write a RSS feed which will pull info from a mySQL DB. In > order for the server > to read the XML file as PHP, I've uploaded a .htaccess file to my server > with this code in it: > > AddType application/x-httpd-php .php .xml > > Then, my feed looks like this: > > <?xml version="1.0" encoding="UTF-8"?> > <rss version="2.0"> > <channel> > <title>FlyRope.com News</title> > <description>News feed for Flyrope.com.</description> > <link>http://www.flyrope.com/feed.xml</link> > <docs>http://blogs.law.harvard.edu/tech/rss</docs> > <lastBuildDate>Fri, 14 Jul 2006 20:48:19 -0500</lastBuildDate> > <pubDate>Fri, 14 Jul 2006 20:46:13 -0500</pubDate> > > <? > mysql_connect('localhost', 'xx', 'xx'); > > mysql_select_db('xx'); > > $newsquery = "SELECT *, UNIX_TIMESTAMP(timeposted) AS pubdate > FROM news > ORDER BY timeposted desc > LIMIT 25"; > $newsresult = mysql_query($newsquery) or die(mysql_error()); > > while ($news = mysql_fetch_array($newsresult)) > { > ?> > <item> > <title><?=htmlentities(strip_tags($news['headline'])); ?></title> > <description><?=htmlentities(strip_tags($news['article'],'ENT_QUOTES'));?></ > description> > <link>http://www.flyrope.com/sections/current/newsfull.php?var=<?=$news > ['newsid'];?></link> > <pubDate><?=strftime( "%a, %d %b %Y %T %Z" , $news['pubdate']); > ?></pubDate> > </item> > <? > } > ?> > > </channel> > <xml/> > > Has anyone successfully done this? And, is my code correct? > ------------------------ Yahoo! Groups Sponsor --------------------~--> Check out the new improvements in Yahoo! Groups email. http://us.click.yahoo.com/6pRQfA/fOaOAA/yQLSAA/HKFolB/TM --------------------------------------------------------------------~-> Community email addresses: Post message: [email protected] Subscribe: [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] List owner: [EMAIL PROTECTED] Shortcut URL to this page: http://groups.yahoo.com/group/php-list Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php-list/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
