Support » Plugins » Question About A Random Post Plugin

  • I was wondering if anyone knows of a way I can get a sinle post, of my choice from a category I chose on my homepage. I want to include an excerpt of the post and a link to the rest of the post… like what is shown on this site http://www.book-blog.com/ above the amazon banner.

    Can someone give me a line of code I can use to do that or is there a plugin?

    Thanks very much

Viewing 5 replies - 1 through 5 (of 5 total)
  • I guess you could do a custom database call, like so:

    <?php
    
    $random_post = $wpdb->get_results("SELECT * FROM $wpdb->posts WHERE post_status = 'publish' AND post_type='post' ORDER BY RAND() LIMIT 1");
    
    echo $random_post->post_content;
    echo '<br />';
    echo '<a href="'.$random_post->guid.'">Read More...</a>';
    
    ?>

    That would echo the whole post content, not just the excerpt… I’m not sure how to get the excerpt right now… anyone?

    Thanks wp_guy for responding.

    o.k. when I add that all that shows up is the read more. Is there some custom/additional code I have to add or change??

    Does anyone else know how to get an excerpt in there as well.

    Aah! my bad… I hadn’t actually tried the code.

    Here’s the good one:

    <?php
    
    $random_post = $wpdb->get_row("SELECT * FROM $wpdb->posts WHERE post_status = 'publish' AND post_type='post' ORDER BY RAND() LIMIT 1");
    
    setup_postdata($random_post);
    
    the_content("Read More...");
    
    ?>

    That one will work fine and show the excerpt (if you use the <!–more–> tag).

    Just noticed the ‘read more…’ link isn’t right for some reason…

    Got it!

    <?php
    
    $rand_posts = $wpdb->get_results("SELECT * FROM $wpdb->posts WHERE post_status = 'publish' AND post_type='post' ORDER BY RAND() LIMIT 1");
    
    foreach($rand_posts as $post){
    
    	setup_postdata($post);
    
    	the_excerpt("Read More...");
    
    }
    
    ?>

    Works 100% (you can choose to use the_content() instead of the_excerpt() if you’d like).

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Question About A Random Post Plugin’ is closed to new replies.