Google Sitemap from Database possible?

[_rajesh_]

Hello everyone,
I wonder is it possible to generate xml sitemap from database(mysql) so that my sitemap will be always updated.I have only one table that contain articles i like to generate xml sitemap from that table.Please suggest how it can be done.

[Mittineague]

Is it possible? You bet. Just use PHP's database functions to get the db results, format them to meet the DTD/Schema requirements, and then use PHP's file functions to write them to an XML file.

[_rajesh_]

thanks mittineaque with ur sugesstion iam able to output xml format in sitemap.php page..i want to know how to generate sitemap.xml from sitemap.php.Can you please.

[stymiee]

All you have to do is pull the data from the database and echo it out as xml. It's no different from echoing out HTML except that you have to follow Google's specified format for their sitemap. They have plenty of documentation about it on their website.

[_rajesh_]

thanks to all.. i successfully done my dynamic google sitemap and submitted to google.

Cheers