I think it’s better to use get_posts
function. You can change the number of posts that you want. I set the category id if you’re in a category page.
<?php
rewind_posts() ;
$args = array( 'numberposts' => 1, 'orderby' => 'rand') ;
$exclude_posts = array() ;
if ( have_posts() ) {
while ( have_posts() ) { the_post();
$exclude_posts[] = get_the_ID() ;
}
}
$args['exclude'] = $exclude_posts ;
if( is_category() ) {
$args['category'] = get_query_var('cat') ;
}
$rand_posts = get_posts( $args ) ;
foreach( $rand_posts as $post ) {
echo '<a href="' . get_permalink( $post->ID ) . '">Random Post</a>';
}
rewind_posts() ;
?>
I hope it helps you 🙂
UPDATE Now exclude the posts showed in this page
Related Posts:
- How can I create a meta_query with an array as meta_field?
- Query multiple meta key values?
- Is there a way of increasing the speed of this query?
- How can I query all users who registered today?
- Reversing the order of posts AFTER the query is performed
- what are the numbers between curly brackets in search query
- When/why does ‘$query->get( ‘tax_query’ );’ return empty?
- How to get link and title of next and previous post on single page
- Create pagination and order according to alphabet
- How to display Section for certain time
- Search custom post type by meta data
- Multipart/formatted MySQL query problem
- Remove [gallery] shortcode altogether
- query multiple taxonomy and show post count
- Categories and products in random order
- add_query_arg() XSS Vulnerability
- When add_query_arg() is necessary?
- Filter query posts by the count of metas for a meta key
- Save default value for empty or missing post meta
- Listing posts by grouping dates
- How to mass delete one line from all posts after site hack
- $wpdb doesn’t appear to work on page inside of a plugin
- Change searched term
- Query Posts By Post Publish Date, but sort by Custom Meta Key
- How to export current year posts from WordPress?
- MySQL variable in query
- Search query -> Show all pages except certain template
- How to execute a SQL-query which contains multiple queries using $wpdb->query?
- Only show upcoming event or current events
- Why a URL with a query is always slower than that without a query?
- Maintaining Queries in URL
- How to orderby multiple meta fields with another meta query
- Query posts using meta_key
- Modify users.php query with multiple taxonomies
- MySql Query very slow
- wpdb query problem to access previous 3 days posts
- WordPress Query wp-terms SLOW
- I can’t figure out what’s wrong with this statement. $wpdb->query update
- Different values for get_author_posts_url and get_the_author (posts 2 posts)
- How to change the amount of posts previewed on a page?
- query statement containing variable won’t execute
- How to get events using multiple custom meta fields?
- Get posts from category with custom query
- Related post based on content
- Random Page Rewrite
- How to interfere to default search to make it search in custom fields?
- How to pull posts into two columns with different image sizes using $counter variable?
- WP_User_Query with more than two custom meta values
- Declaring a var, placing it in a query and using the output of the query?
- Select column name dynamically mySQL Query
- WordPress Mysql query and Duplicate
- Sort query_terms_list for post_tags alphabetically
- Target a page with query
- List only parent attributes on woocommerce admin atrributes page
- Merge CPT Taxonomy and Post Taxonomy in $query->set
- How do I get specific readable results from this query and array results
- I want to get on those users their meta value are like “AGENT” .. but this query is not working
- Add rewrite rule for archive search
- How to create a filter and add query params to all links
- Get 2 meta values from meta key column
- WordPress add_query_arg from ajax and make url friendly
- Query Post interferes with Pagination
- My custom pagination not displaying
- Order WordPress Query by Custom Field While Still Using Tax_query Argument
- Wpdb->last_query returns bad query
- How to get all images in Media Gallery with pagination?
- WP search exclude last letter from string
- Are there any best practices for creating a Like/Favourite feature in WordPress using custom MySQL tables and without any plugins?
- Query reversed when I use “category__not_in”
- How to reduce the load / no of queries on MySql Database
- Performance of wp_get_attachment_image_srcset() and wp_get_attachment_image_url()
- YearMonth datequery
- $query->set( ‘post_type’, ‘post’ ); not working
- How i make a custom sql query for Woocommerce
- Display result from custom post meta query
- Show certain number of post from tags
- Wpdb empty result only if language is Russian
- What is the best way to query posts based on live data?
- Include custom table in query
- How to fix this insert? Don’t work for me!
- Display Upload Author & Get Uploaded Post ID
- Display list of most recent grandchild (third tier) pages
- How can I display a number to represent the order of post?
- How to query custom post type one after another
- Update vs Insert logic but the last key is always inserted?
- Sort order in get_posts [closed]
- Query unique author ids with published post of type job
- Wpdb generates too many queries
- Custom Query for searching through custom fields
- Query posts alphabetically within this function
- Conditional Tag Custom Querys?
- WordPress Unknown Query
- List of buyers for each product
- query posts only works on the first page
- Custom Query for wp_posts using wp_postmeta
- WP Query outputs three items within a div
- How do I troubleshoot Maximum execution time of 60 seconds exceeded in updating a Media File?
- update $wpdb one query
- Admin Post List table Query filtering “WHERE” for custom post type
- How to use a dynamic term id for the query block