详解WordPress中怎么建立文章存档页面

get_results("
    SELECT post_title, ID, post_name, slug, {$wpdb->prefix}terms.term_id AS catID, {$wpdb->prefix}terms.name AS categoryname
    FROM {$wpdb->prefix}posts, {$wpdb->prefix}term_relationships, {$wpdb->prefix}term_taxonomy, {$wpdb->prefix}terms
    WHERE {$wpdb->prefix}posts.ID = {$wpdb->prefix}term_relationships.object_id
    AND {$wpdb->prefix}terms.term_id = {$wpdb->prefix}term_taxonomy.term_id
    AND {$wpdb->prefix}term_taxonomy.term_taxonomy_id = {$wpdb->prefix}term_relationships.term_taxonomy_id
    AND {$wpdb->prefix}term_taxonomy.taxonomy = 'category'
    AND {$wpdb->prefix}posts.post_status = 'publish'
    AND {$wpdb->prefix}posts.post_type = 'post'
    ORDER BY {$wpdb->prefix}terms.term_id, {$wpdb->prefix}posts.post_date DESC");

    $postID = 0;
    if ( $categoryPosts ) :
        $category = $categoryPosts[0]->catID;
        foreach ($categoryPosts as $key => $mypost) :
            if($postID == 0) {
                echo '
分类: '.$mypost->categoryname."\n";
                echo '
';
            }
           
            if($category == $mypost->catID) {          
?>
    
post_title; ?>
catID;
                $postID++;
            }
            else {
                echo "
\n
";
                echo '
分类: '.$mypost->categoryname."\n";
                echo '
';
?>
    
post_title; ?>
catID;
                $postID = 1;
            }
        endforeach;
    endif;
    echo "
\n
";
?>

页面

get_results("
        SELECT post_title, post_name, ID
        FROM {$wpdb->prefix}posts
        WHERE post_status = 'publish'
        AND post_type = 'page'");

    if ( $mypages ) :
        foreach ($mypages as $mypage) :
?>
    
post_title; ?>
    \n"; endif; ?>

查看 sitemap.xml

.myArchive {
	line-height:18px;
	margin:1.5em 0;
	color:#555555;
	font-size:14px;
}
.myArchive h2 {
	font-size:16px;
	margin:0 0 10px;
	font-weight:bold;
}
.myArchive ul {
	line-height:21px;
	padding:0 0 0 2em;
}
.myArchive ul li {
	background:none;
	list-style-type:disc;
	margin:0;
	padding-left:10px;
}
.myArchive a {
	color:#2970A6;
	outline:medium none;
	text-decoration:none;
}
.myArchive a:hover {
	text-decoration:underline;
}
.myArchive ul li ul {
	margin:10px 0;
}
.myArchive ul li ul li {
	list-style-type:circle;
}

echo '
';
wp_get_archives('type=postbypost&show_post_count=1');
echo '
';