http://wordpress.org/support/ WordPress › Support Topic: Generate a Random post but exclude several post en Thu, 26 Nov 2009 09:33:19 +0000 http://wordpress.org/support/topic/281985#post-1122255 Wed, 01 Jul 2009 06:04:11 +0000 johnkolbert 1122255@http://wordpress.org/support/ <p>I think you're looking for the "NOT" mysql operator. It negates whatever follows it, so we'll use a "NOT IN", like this:</p> <p><code>$randomPost = $wpdb-&gt;get_var(&quot;SELECT guid FROM $wpdb-&gt;posts WHERE post_type = &#39;post&#39; AND post_status = &#39;publish&#39; AND ID NOT IN ($pageids) ORDER BY rand() LIMIT 1&quot;);</code></p> <p>Hope that helps </p> http://wordpress.org/support/topic/281985#post-1110042 Fri, 19 Jun 2009 16:37:05 +0000 jeffdempsey 1110042@http://wordpress.org/support/ <p>I am writing a short script that is designed to generate a random post. I also have a session where I keep track of the post they have been to already. I put these pages in a comma delimited variable and attempted exclude them. Here is my sql statement:</p> <p>Here is what it looks like in PHP:</p> <p><code>$randomPost = $wpdb-&gt;get_var(&quot;SELECT guid FROM $wpdb-&gt;posts WHERE post_type = &#39;post&#39; AND post_status = &#39;publish&#39; AND ID &lt;&gt; ($pageids) ORDER BY rand() LIMIT 1&quot;);</code></p> <p>Here is what it looks like when the variables are gone:</p> <p><code>SELECT guid FROM hb_posts WHERE post_type = &#39;post&#39; AND post_status = &#39;publish&#39; AND ID &lt;&gt; (1,15,13,20,17,11,5,9,3,0) ORDER BY rand() LIMIT 1</code></p> <p>I can get the code to work fine if I exclude just one post, so the error is in my (1,1,5,20....). </p>