Hallo,
mein blog hat eine tag-cloud, ich möchte die sortierung aber umkehren: sprich die fettesten, also meist benutzen tags sollen oben stehen.
siehe: HNSLatest.com - Croatian football headlines from around the globe
da es kein plugin ist hier der entsprechende auszug aus der sidebar.php
PHP
<ul id="tab_content_popular" class="tab_content_list"> <!-- Popular posts -->
<?php
$now = gmdate("Y-m-d H:i:s",time());
$lastmonth = gmdate("Y-m-d H:i:s",gmmktime(date("H"), date("i"), date("s"), date("m")-1,date("d"),date("Y")));
$popularposts = "SELECT ID, post_title, post_date, comment_count, COUNT($wpdb->comments.comment_post_ID) AS 'popular' FROM $wpdb->posts, $wpdb->comments WHERE comment_approved = '1' AND $wpdb->posts.ID=$wpdb->comments.comment_post_ID AND post_status = 'publish' AND post_date < '$now' AND post_date > '$lastmonth' AND comment_status = 'open' GROUP BY $wpdb->comments.comment_post_ID ORDER BY popular DESC LIMIT 11";
$posts = $wpdb->get_results($popularposts);
$popular = '';
if($posts){
foreach($posts as $post){
$post_title = stripslashes($post->post_title);
$post_date = stripslashes($post->post_date);
$comments = stripslashes($post->comment_count);
$guid = get_permalink($post->ID);
$popular .= '<li><span class="title"><a href="'.$guid.'" title="'.$post_title.'">'.$post_title.'</a></span><br/>
<span class="meta">With <a href="'.$guid.'#commenting" title="Read the comments on '.$post_title.'">'.$comments.' comments</a> since '.$post_date.'</span></li>';
}
}echo $popular;
?>
</ul> <!-- END -->
danke euch