How to create sitemap for wordpress blog?

[DaHLiA]

I tried Google XML Sitemap generator plug-in but it keeps giving me the error:

There was a problem while notifying Google. View result
There was a problem while notifying MSN.com. View result
There was a problem while notifying Ask.com. View result

When clicked on the view result link, it takes me to my blog's 404 page not found page!

So, i tried this another approach which I found via google.

1. Installed and activated RunPHP plug-in. Set the permission for Admin
2. Created a new Page via Wordpress admin panel and entered the below code

PHP Code:

<?php
global $wpdb;

$allposts = $wpdb->get_results(”SELECT * FROM wp_posts WHERE post_type=’post’ AND post_status=’publish’ ORDER BY post_date DESC”);

foreach($allposts as $ap) {
$perma = get_permalink($ap->ID);
print “<a href=” . $perma . “>” . $ap->post_title . “</a><br/>”;
}

?>

Now my page's content area is blank.

Any idea how can I resolve this?
Thanks!

[Locomotive]

DaHLiA, it is quite difficult to understand. Have you tried to ask the same on the WP support forums? It seems that you are trying to edit wrong file.
BTW what sitemap are you trying to install? Google or ordinary one?

[DaHLiA]

Nope Locomotive, have not yet asked the WP Support forum. I shall do that.
I want to generate a Google Sitemap that is why I used that plug-in but that was not working for me. So in the meantime, I wanted to create a simple sitemap and that is why I tried that second method which I mentioned above. Now neither that works.

Can anyone help me with generating a simple sitemap for my blog if you have no idea with that plug-in issue, please?

[Izzmo]

This may be a stupid question, but did you register an account on Google, Live and Yahoo!?

[DaHLiA]

Are you referring to the Gmail, MSN and Y!Mail accounts Izzmo? Yup, I have.

Meanwhile I raised this query with WP Support forum. One of the moderators there advised me that this could be a problem with my host which probably is not allowing outgoing links. I don't understand what he exactly meant tho. I have again raised a query there

[teampower]

why dont just use wp sitemap pluggin