TalkPHP - View Single Post

Haris · 01-18-2008, 07:17 PM

Quote:

Originally Posted by Dan

Still trying to display random posts in wordpress, I have this working with the follwing:

Code:

<?php global $wpdb; $numposts = 40;
            $rand_posts = $wpdb->get_results("SELECT * FROM $wpdb->posts WHERE post_status = 'publish' AND post_type = 'post' AND  post_category != 1 ORDER BY RAND() LIMIT $numposts");
            foreach($rand_posts as $post) : setup_postdata($post);

            $title = $wp_query->post->post_title; $str = strtolower($title); $newtitle = str_replace(" ", "-", $str); ?>
            <a href="<?php the_permalink() ?>" title="<?php the_title(); ?> Wallpaper"><img src="<?php echo get_option('siteurl'); ?>/images/160x120/<?php echo $newtitle ?>.jpg" alt="<?php the_title(); ?>" /></a>
            <?php endforeach; ?>

However I want to exclude a category from getting pulled up. That category is the wordpress default - cat_ID=1.

Any suggestions?

PHP Code:


			
$wpdb->get_results("SELECT * FROM wp_posts, wp_term_taxonomy, wp_term_relationships WHERE wp_posts.post_type = 'post' AND wp_posts.post_status = 'publish' AND wp_term_taxonomy.taxonomy = 'category' AND wp_term_taxonomy.term_id != 1 AND wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id AND wp_posts.ID = wp_term_relationships.object_id ORDER BY RAND()")

That'll help ya generate random posts.