-1

Possible Duplicate:
How to create a sitemap using PHP & MySQL

So I'm kinda stuck here. I have a website with a pretty big database, that constantly changes. Now I want to help the search engines by supplying a sitemap.xml file. Normally I would use a webservice that would do this, but thats not really possible in this case.

To be honest. I have no clue where to start. How would I go about doing this? Sorry if this is a too basic question, but Google couldn't help me.

Edit: Some more info. DB is currently 1k pages. Want to go up to like 10k. I use Mysql to echo this from my database, and then htaccess to rewrite the URLs. (PHP's get ID, etc)

Community
  • 1
  • 1
user1333327
  • 795
  • 1
  • 6
  • 11

1 Answers1

0

You need to install a crawler of doing it like a webservice. The easier way is to write a php script and generate sitemap XML file by yourself.

Write a query to get the links from your database and then iterate over it to create a sitemap.

See this post for example php script How to create a sitemap using PHP & MySQL

Community
  • 1
  • 1
Ravi Rajendra
  • 688
  • 4
  • 11