WordPress › Support Topic: Latest post per category, from category 1 -8 on homepage

WordPress › Support Topic: Latest post per category, from category 1 -8 on homepage http://wordpress.org/support/ WordPress › Support Topic: Latest post per category, from category 1 -8 on homepage en Thu, 26 Nov 2009 01:42:34 +0000 kirmann on "Latest post per category, from category 1 -8 on homepage" http://wordpress.org/support/topic/222993#post-1171962 Wed, 12 Aug 2009 04:51:39 +0000 kirmann 1171962@http://wordpress.org/support/ continue of the topic. case : we wanna split the first post (one category) with the second post or next post. And the next post is only two post. question : How the query to do it ? Thanks, before MAD000 on "Latest post per category, from category 1 -8 on homepage" http://wordpress.org/support/topic/222993#post-1171182 Tue, 11 Aug 2009 16:45:42 +0000 MAD000 1171182@http://wordpress.org/support/ Hi all, I have been trying to find a simpler, more efficient way to display different posts depending on different conditions. For now I wrote the following script to retrieve posts for a specific category named 'Inspiration' and that should be displayed in descending order based on the number of comments (popularity). I would welcome any suggestions to shorten this (I feel there is another way!!) here is the code: <pre><code><div class="inspirational-post-box"> <h1 class="heading-small">Inspirational Posts</h1> <?php $sql = "SELECT * " . "FROM $wpdb->posts AS p " . "WHERE p.post_status = 'publish' " . "AND p.post_type = 'post' " . "AND p.ID IN (SELECT tr.object_id " . "FROM $wpdb->term_relationships tr " . "WHERE tr.term_taxonomy_id IN (SELECT tt.term_taxonomy_id FROM wp_term_taxonomy AS tt " . "INNER JOIN $wpdb->terms AS t ON t.term_id = tt.term_id " . "WHERE (tt.term_id = (SELECT tt.term_taxonomy_id " . "FROM $wpdb->term_taxonomy AS tt " . "INNER JOIN $wpdb->terms AS t ON tt.term_id = t.term_id " . "WHERE tt.taxonomy = 'category' AND t.name = 'Inspiration') OR tt.parent = (SELECT tt.term_taxonomy_id " . "FROM $wpdb->term_taxonomy AS tt " . "INNER JOIN $wpdb->terms AS t ON tt.term_id = t.term_id " . "WHERE tt.taxonomy = 'category' AND t.name = 'Inspiration')))) " . "ORDER BY p.comment_count DESC LIMIT 12"; $result = $wpdb->get_results($sql); foreach ($result as $post) { setup_postdata($post); ?> <div class="entry-small"> <a href="<?php the_permalink() ?>" rel="bookmark" title="Permanent Link to <?php the_title_attribute(); ?>"><img class="thumbnail-small" src="<?php bloginfo('template_url') ?>/images/<?php echo get_post_meta($post->ID, 'post-thumbnail', true); ?>" width="50" height="50" alt="Small Thumbnail" /></a> <h2 class="title-small"> <a href="<?php the_permalink() ?>" rel="bookmark" title="Permanent Link to <?php the_title_attribute(); ?>"><?php the_title(); ?></a> </h2> </div> <?php } ?> </div></code></pre> [signature moderated Please read the <a href="http://wordpress.org/support/topic/68664?replies=6">Forum Rules</a>] funkboybilly on "Latest post per category, from category 1 -8 on homepage" http://wordpress.org/support/topic/222993#post-1163459 Wed, 05 Aug 2009 04:13:45 +0000 funkboybilly 1163459@http://wordpress.org/support/ sorry, I posted wrong info... Rocksijen on "Latest post per category, from category 1 -8 on homepage" http://wordpress.org/support/topic/222993#post-1155587 Wed, 29 Jul 2009 18:02:08 +0000 Rocksijen 1155587@http://wordpress.org/support/ ohhhhhh ! thanks! i am very very hapy! digitalrenewal on "Latest post per category, from category 1 -8 on homepage" http://wordpress.org/support/topic/222993#post-1113930 Tue, 23 Jun 2009 17:18:20 +0000 digitalrenewal 1113930@http://wordpress.org/support/ thank you tgiokdi!!! ive been trying to figure this out for 2 days. i knew it had to be simple, it built right into worpdress 2.8, but i couldnt get anyones code to work. :) im cartwheel happy! t31os on "Latest post per category, from category 1 -8 on homepage" http://wordpress.org/support/topic/222993#post-1021319 Fri, 20 Mar 2009 13:33:27 +0000 t31os 1021319@http://wordpress.org/support/ Not sure if this be of use to any of you guys, but i made a function for looping through categories and posts... Accepts categories as an array... See here if of use.. <a href="http://www.t31os.co.uk/wordpress-catx/" rel="nofollow">http://www.t31os.co.uk/wordpress-catx/</a> pesocky on "Latest post per category, from category 1 -8 on homepage" http://wordpress.org/support/topic/222993#post-1020812 Thu, 19 Mar 2009 23:16:58 +0000 pesocky 1020812@http://wordpress.org/support/ Thanks! I fixed same error. c64glen on "Latest post per category, from category 1 -8 on homepage" http://wordpress.org/support/topic/222993#post-1006175 Thu, 05 Mar 2009 11:45:29 +0000 c64glen 1006175@http://wordpress.org/support/ Thanks, I actually fixed my problem (after many many hours) by replacing <pre><code>query_posts($query); while (have_posts()) : the_post();</code></pre> with ` $recent = new WP_Query($query); while($recent->have_posts()) : $recent->the_post(); ` davesgonebananas on "Latest post per category, from category 1 -8 on homepage" http://wordpress.org/support/topic/222993#post-1005747 Thu, 05 Mar 2009 00:17:45 +0000 davesgonebananas 1005747@http://wordpress.org/support/ When you use query_posts in the sidebar you are overwriting the main query that contains the posts for the page you are on! I think you can use wp_reset_query() after the loop in the sidebar to get round this. c64glen on "Latest post per category, from category 1 -8 on homepage" http://wordpress.org/support/topic/222993#post-1005666 Wed, 04 Mar 2009 22:15:20 +0000 c64glen 1005666@http://wordpress.org/support/ I'm current having the same problem (so I hope you don't mind me tagging this along) The following bit of code display the latest post in six selected categories in my side bar. (excuse the code it's a little messy) <pre><code><?php for ($i = 1; $i <= 6; $i++) { if ($i==1) {$oi_cat = "article";} if ($i==2) {$oi_cat = "music";} if ($i==3) {$oi_cat = "video";} if ($i==4) {$oi_cat = "podcasts";} if ($i==5) {$oi_cat = "blog";} if ($i==6) {$oi_cat = "links";} ?> <div class="spoiler clearfloat"> <IMG src="<?php bloginfo('stylesheet_directory'); ?>/images/t-<? echo $oi_cat;?>.png" alt="<? echo $oi_cat;?>" width="300" height="32" style="margin:0px; padding:0px;"> <?php $query= 'category_name='.$oi_cat.'&showposts=1'; query_posts($query); ?> <?php while (have_posts()) : the_post(); ?> <div class="clearfloat"> <h4 class="title"><a href="<?php the_permalink() ?>"> <?php the_title(); ?> </a></h4> <? $thumb = get_post_meta($post->ID, "thumb", true); if ($thumb != "") { ?> <img src="<?php $values = get_post_custom_values("thumb"); echo $values[0]; ?>"" alt="<?php the_title(); ?>" width="80" height="80" align="left" class="left" id="spoiler" /> <?php } the_excerpt(); endwhile;?> <div class="right"><a href="/category/<? echo $oi_cat;?>/">More <? echo $oi_cat;?> &raquo;</a></div> </div> </div> <? } ?></code></pre> If I attempt to view my blog via the front page "/" or via a blog post "/blog post name/" I get a blank page. However if I view this on a category page e.g. "/category/article/" it works fine. any ideas why? Dreamsinplay on "Latest post per category, from category 1 -8 on homepage" http://wordpress.org/support/topic/222993#post-997137 Tue, 24 Feb 2009 23:40:40 +0000 Dreamsinplay 997137@http://wordpress.org/support/ I am seeking to have my website updated ASAP, but due to the fact that I am a college student trying to start a non-profit organization I have a very limited budget. My current website is at <a href="http://www.dreamsinplay.org" rel="nofollow">http://www.dreamsinplay.org</a> and uses Wordpress. We are a very recently founded nonprofit organization which seeks to connect socially beneficial dreams with efficient and productive resources. In order to seek out the best “ideas”, we are seeking to enable our website to allow members to post ideas where other members will read, rate, and comment on them. With this complete, we will seek out the best ideas, and connect them to the necessary resources. I would like this part to replicate <a href="http://wordpress.org/extend/ideas" rel="nofollow">http://wordpress.org/extend/ideas</a> with the titles of the post on the left and the ratings on the right. You will not be able to rate the idea from the listings, and must go to the ideas’ post to rate and comment. Currently, I have a wordpress plugin that allows registered members to submit posts. What I am looking now for is someone to help me create the ideas page with the titles on the left and the ratings on the right. I believe this should be a very quick and easy project, but haven’t been able to do it. I am very willing to do it myself, if someone could guide me. Again, I just need something that looks like this: <a href="http://wordpress.org/extend/ideas" rel="nofollow">http://wordpress.org/extend/ideas</a> Furthermore, I would like to be able to do Idea Categories, such as weekly contest, monthly contest, etc. if someone has any suggestions about this. Thanks in advance for your time and consideration! Sincerely, Andrew CP Kelley nando99 on "Latest post per category, from category 1 -8 on homepage" http://wordpress.org/support/topic/222993#post-985495 Fri, 13 Feb 2009 20:49:05 +0000 nando99 985495@http://wordpress.org/support/ just wanted to say that I tried what tgiokdi said and it worked GREAT!! thanks Dgold on "Latest post per category, from category 1 -8 on homepage" http://wordpress.org/support/topic/222993#post-929268 Thu, 18 Dec 2008 00:54:44 +0000 Dgold 929268@http://wordpress.org/support/ This page kind of tells you how to do it, <a href="http://codex.wordpress.org/Function_Reference/WP_Query" rel="nofollow">http://codex.wordpress.org/Function_Reference/WP_Query</a> Unfortunately the way it's written is kind of difficult to understand tgiokdi on "Latest post per category, from category 1 -8 on homepage" http://wordpress.org/support/topic/222993#post-929257 Thu, 18 Dec 2008 00:34:55 +0000 tgiokdi 929257@http://wordpress.org/support/ You may want to do what I did on <a href="http://www.startrekbookclub.com">http://www.startrekbookclub.com</a> with the <a href="http://codex.wordpress.org/Template_Tags/query_posts">query posts</a> bit of code: ' <?php query_posts('orderby=name&order=asc&cat=43&showposts=100'); ?> <?php while (have_posts()) : the_post(); ?> <a>"><?php the_title(); ?></a> <?php endwhile;?> ' This code will only show the titles of the posts, but you can use the content or the excerpt with it too to have some lead in text to the articles. I'm also using some code to show the children of a specific category: ' <?php wp_list_categories('title_li=&orderby=name&order=asc&child_of=8'); ?> ' my first time trying to past code into these forums so I apologize if this post ends up looking like carp. Which is a fish, just FYI. KevinPaquet on "Latest post per category, from category 1 -8 on homepage" http://wordpress.org/support/topic/222993#post-920603 Thu, 11 Dec 2008 13:46:25 +0000 KevinPaquet 920603@http://wordpress.org/support/ You're using a WordPress Magazine style theme, right? netbuddy34 on "Latest post per category, from category 1 -8 on homepage" http://wordpress.org/support/topic/222993#post-916699 Sat, 06 Dec 2008 23:55:06 +0000 netbuddy34 916699@http://wordpress.org/support/ Hi, Im trying to figure out how i could possibly have the latest post for each category listed on my homepage. I have say 8 boxes, for 8 differant categories. I would like to display the latest post for each of those categories in a specific order, not name or ID, i need to be able to set the order in a custom way. Is this possible without having a bunch of seperate loops? I could probably have 8 IF statements, but im wondering if there is something more compact?