How to create XML sitemap generator

I have been asked to create a generator which creates an automated sitemap every week with information in database, and then transmits the new file to google for processing.
I just wanna know , what is the best way to do this?
any help would be greatly appreciated.
Thanks in advance.

We haven’t done the automatic submission to Google yet, so would bee keen to hear what ideas people have on this. We have made our own sitemap generator with our CMS with VB so let us know what you are using and we might be able to help.

A good starting point would be to look at the protocol of submitting a sitemap via the Google Webmaster Tools API, at
http://code.google.com/apis/webmastertools/docs/2.0/developers_guide_protocol.html#Sitemaps_Submitting or
https://developers.google.com/webmaster-tools/docs/2.0/developers_guide_protocol?hl=zh-CN#Sitemaps_Submitting

This is an example of it is down with Java but I would imagine you could use VB, PHP etc to do this also.
http://code.google.com/apis/webmastertools/docs/2.0/developers_guide_java.html#AddingSitemaps

In regards to generating the xml site map what technology do you have to do this with eg: PHP, VB, C# etc?

Kind regards,

<snip/>

Thanks for the help , I will be using PHP to do this…any references for PHP will be greatly appreciated…

Regards