Generating a Sitemap from Tables within MySQL Database

Discussion in 'XML & RSS' started by rakers8, Sep 30, 2009.

  1. #1
    I've been researching this for about a week and I'm unable to get a clear grasp of it. If anyone could humor me it would be much appreciated.

    I started with a company:
    http://www.rentittoday.com

    It's a pretty extensive website that is predominately DHTML. As you can see, we have multiple categories (vacation rentals, exotic cars, etc.) Each of these categories has a unique table in our MySQL database, where individual listings are stored.

    I need some recommendations on how I can create an xml sitemap that creates a direct avenue to each of our individual listings from pulling from the MySQL database. That way, if someone posts a new item, it's automatically populated into the (dynamic?) sitemap.

    My plan is to have a basic sitemap that exports our static landing pages (sitemap1.xml) and have the alternate dynamic sitemap that pulls all of our listings (sitemap2.xml)

    I've extensively researched this and have seen php scripts that claim to do this, among other things. Unfortunately I'm having a hard time wrapping my mind around it. If it takes a programming pedigree should I consider sites like 'rent a coder' (etc)? I'm not sure how daunting of a task the above is.
    Is there a program or generator that streamlines this process?

    Thanks.
     
    rakers8, Sep 30, 2009 IP
  2. rakers8

    rakers8 Peon

    Messages:
    11
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    No response? Should I post this in a different forum?
     
    rakers8, Oct 1, 2009 IP