http://www.catswhocode.com/blog/super-useful-wordpress-hacks-and-snippets
You source? I made a widget that does just that, on this same code.
To sort:
<?php
$args = array(
'post_status' => 'publish',
'meta_key' => 'post_views_count',
'orderby' => 'meta_value_num',
'order' => 'ASC'
);
$the_query = new WP_Query($args); //http://codex.wordpress.org/Class_Reference/WP_Query
//the loop
while ( $the_query->have_posts() ) : $the_query->the_post();
//do your magic
endwhile;
Related Posts:
- Undefined function mysql_connect()
- MySQL column count doesn’t match value count at row 1 [closed]
- dbDelta support for FOREIGN KEY
- How to correctly submit a search form and display the result in an independent page
- Check if post of title already exists
- $wpdb->delete column values IN ARRAY()?
- How to use update and delete query in wordpress
- Custom SQL query to get List of posts with featured image url
- Does WordPress cache get_user_meta() results?
- Delete post revisions on post publish
- Using Echo in ShortCode – Stuck
- Problems migrating WordPress to localhost
- MySQL query performed 4 times inside loop
- Show only one post for each author ( Page loads too slow )
- error importing localhost export file to server
- How to sort results from a custom database table
- Update some database fields when post is saved
- WP database error for comments_popup_link()
- sql query to put quotes around numbers in img tag
- No wp-config.php file on local install of wordpress – site still displays
- Use ajax to update_post_meta
- Insert all post IDs in new database table
- What SQL / WordPress queries would need a nonce?
- Different database query in function.php using mysqli
- Strange wordpress slowness
- Setting All Drafts to ‘exclude-from-catalog’ in WooCommerce
- Get WooCommerce product details and transfer them to a custom DB table
- How to securely provide a $_POST var in WP_Query with PHP 7?
- Create WP_Query to search for posts by their categories or their parent/child categories
- What is a valid parent for get_terms()?
- WSoD being caused by this piece of code
- How to display data from custom table in wordpress phpmyadmin
- Update results, Before deleting the related category [closed]
- get_posts() and WP_query limits ‘AND’ conditions to a maximum of 6 for meta value queries in WordPress
- Replacing mysql_escape_string in a custom plugin when moving to PHP7
- Weird 404 URL Problem – domain name being placed at end of urls
- database sent to a JSON file
- $wpdb->insert() does not Insert record in a table
- Help with a $wpdb MySQL Query
- How i can obtain all the post meta for a specific post as an array?
- Can’t Query Custom Table Using $wpdb Method
- $wpdb returns duplicate posts
- Update postmeta after theme switch
- Should I use WordPress to skin a database website?
- Creating Database Table vs. Adding MetaData to Post & User
- WordPress Custom SQL Table with UserID Filter for results
- How can I add a new row in a separate database when someone registers via WordPress?
- How to use mysql LIKE with wpdb?
- Submitting a form, using Ajax, to run a SQL Select query based on user input from the form
- WordPress WP_Query without query GET parameters
- How to use AJAX in WordPress in MYSQL query?
- Use variable in SQL statement
- Processing ajax call to php to insert into mysql database
- WPDB secure custom form
- phpMyAdmin error #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’
- Query the links Database
- How to create Loop code for Menu using WordPress?
- WordPress Custom Query: Combining Two Functions
- MySQL Query Returns Array () In Shortcode
- How to WP_Query posts order by parent title?
- Passing in MySQL prepare statement parameter separately throwing error
- Convert a column of a table containing an Array as response in HTML
- Database SQL query error
- Error establishing a database connection (Set-up locally)
- MYSQL TIMESTAMP when adding DATE_FORMAT then the output is blank, PHP conflict?
- Updated Php version from 5.4 to 7.2 and getting “PHP installation missing the MySQL extension needed by WordPress”
- how to get data from two different table from wordpress database
- Passing Current User ID into SQL statement
- How to optimize and reduce excessive database queries
- How to insert multiple rows and columns in database using array
- Store GA Client ID in User DB
- PHP 7.2.18 | Your PHP installation appears to be missing the MySQL extension which is required by WordPress
- Error inserting into custom table – Object of class wpdb could not be converted to string [closed]
- Windows Setup: Error establishing a database connection
- Need help with format of nested array in MySQL
- WAMP SERVER Command Prompt SET PATH=%PATH%
- Inserting other fields to existing registration form in a WordPress theme
- Advanced WordPress SQL Query
- Splitting table data to pages with numbers
- How can get all users by current user meta (array)?
- Site doesnt work once PHP changed to 7.1
- Add two or multiple functions in WordPress Post or Page
- How to detect if a revision was made by woocommerce or wordpress?
- WordPress WPDB::insert 13th param is always blank (only if format)
- Ajax not updating to database
- can’t delete a row from post_meta table
- MySQL query in WordPress with AJAX
- Processing forms with php to wordpress database
- How to connect database table to each registered wordpress user.
- retrieve wordpress post-meta using php not wordpress functions
- Splash pages on a high traffic site
- Using the same shortcode to show any table from the database
- Predefine Magazine Style Layouts
- I am unable to fetch json data from wp_db
- Submit cf7 form to cfdb as pdf/BLOB [closed]
- How to send push notification in android using php? [closed]
- How to set variable to specific field when querying
- Getting invalid user ID error when creating a new user with wp_insert_user
- Custom form that stores data in mysql database
- Trying to GET data with ajax from database and show in fullcalendar