tonygeer

This worked perfectly, thanks!

For those showing 0|0 – you need to change your publishing settings to be published at whatever.blogspot.com and it will work when you try to do the import.

Hope that helps.

I’m really at a loss here Michael, I don’t know what to do with that code…

What I meant was that it says I have to replace the SQL query with my own, so I need to replace

SELECT * FROM wp_table;

with the WordPress SQL command that displays the list of subpages. Which is the equivalent of calling the get_pages function here, but I don’t know the actual SQL that is used.

Thanks Michael, this looks very promising! However, how do I figure out SQL query for displaying all the subpages of a specific page?

Okay so it is possible then. Are there any pointers you can give me on how to get it done, I’m at a loss.

Thanks for taking a look esmi, but I’m not sure how that could help. Is it the offset function?

mankot, thanks a lot! That worked. I had the exact problem that haryadimas had – I inserted some code to show the title of the most recent posts above it and it stopped working.

Thanks again!

dressed – this is exactly what I was looking for, thanks!

Hi Michael, that worked perfectly, thankyou!

Just in case anyone missed it, I’m still looking for a solution to this issue. Thanks.

I found exactly what I was looking for here:

https://kwebble.com/blog/2007_08_15/archives_for_a_category

If you use it, also remember to go into the options area and turn off canonical URLs so that it works properly.

I’m sorry if I didn’t explain this properly. Let’s say I have only two categories, CatA and CatB.

If I use the get archives function, it’ll list all the months that I have made blog posts. And let’s say I click on January 2008, it will show me all the posts in CatA and CatB that I made during that month.

I want to be able to show two lists of monthly archives, one for each of the categories. So the first list will display the months that I made posts in CatA, and clicking on one of those months will only show posts from CatB.

Likewise the second list will show months in which I made a post to CatB, and clicking on one of those months will display only those posts that I made in that month under CatB.

Is this any clearer?

That’s the thing, the host doesnt have phpMyAdmin ??

Can I do anything with Shell access or anything like that?

Thanks snipe, I’ll think about everything that you said.