Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4
  1. #1
    Regular Coder GSimpson's Avatar
    Join Date
    Aug 2006
    Location
    New Zealand
    Posts
    268
    Thanks
    9
    Thanked 0 Times in 0 Posts

    The old rss question...

    It seems like one of those questions that has popped up every week or two, but i'm gonna ask it any way,

    I want to have it so my RSS file gets the last 5 entries into my mysql table, I thought that maybe you'd run the query in the xml file and have it do the old while($data = mysql_fetch_array($query)) , or something like that. Any one have a solution or a good tutorial.

    Thanks, Glyn.
    The internet is my Sandbox, and notepad is my Spade n' Bucket.

  • #2
    Regular Coder meth's Avatar
    Join Date
    Jan 2003
    Posts
    262
    Thanks
    0
    Thanked 9 Times in 9 Posts
    Well, ya basically; that's the gist of it. You're using php/mysql to output as an xml file instead of html. The while loop will output the nodes in the xml schema.
    I do Web Design, Brisbane based.
    More time spent in PHP/MySQL Web Development.
    And Search Engine Optimisation takes up the rest of it.

  • #3
    Regular Coder GSimpson's Avatar
    Join Date
    Aug 2006
    Location
    New Zealand
    Posts
    268
    Thanks
    9
    Thanked 0 Times in 0 Posts
    So does this mean I will have to, every time I make a post, rewrite a file? Or is there a way I can have a set code in an xml file and just leave it?
    The internet is my Sandbox, and notepad is my Spade n' Bucket.

  • #4
    Regular Coder meth's Avatar
    Join Date
    Jan 2003
    Posts
    262
    Thanks
    0
    Thanked 9 Times in 9 Posts
    Here's a good reference about rss http://www.rssboard.org/rss-specification

    And and magpierss is a good start for generating your own feed: http://magpierss.sourceforge.net/
    Last edited by meth; 08-28-2007 at 11:00 AM. Reason: dead link
    I do Web Design, Brisbane based.
    More time spent in PHP/MySQL Web Development.
    And Search Engine Optimisation takes up the rest of it.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •