Hey, thanks, Phill! That worked! --- In [email protected], "Phill Sparks" <[EMAIL PROTECTED]> wrote: > > 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 --------------------~--> Great things are happening at Yahoo! Groups. See the new email design. http://us.click.yahoo.com/TISQkA/hOaOAA/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/
