Up until now I've been using a sitemap generator to create HTML sitemaps.
As I'm adding new pages frequently this is getting a bit of a pain in the ass to update. I am thinking it would be easier to create a sitemap using an SQL query to my database so that all the links are created dynamically.
As the page would have to be in php, i'm a bit confused if I could save it with a .html extension? But then I guess the php wouldn't work... I read somewhere about outputting an XML sitemap from php, can a similar thing be done for html?