Sort WordPress posts by numerical custom fields

5 comments

1. If you would like to do it manually (though the answers referencing WP_Query are better options), a reasonably nice treatment might use array_multisort:

   $arr = array(
     '$116.99',
     '$12.95',
     '$149.00',
     '$15.99'
   );
   
   $keys = array();
   
   foreach ($arr as $value) {
       $keys[] = floatval(substr($value, 1));
   }
   
   array_multisort($keys, SORT_ASC, $arr);
   

   Log in to Reply

2. Use the WP_Query class and the orderby=meta_value_num parameter to sort numerically. Also, make sure you store the price in the custom field as a number without the “$” prepended.

   $query = new WP_Query( array ( 'orderby' => 'meta_value_num', 'meta_key' => 'price' ) );
   

   $query then contains rows of posts sorted numerically by price.

   Log in to Reply

3. I haven’t had a look at your code but you this has to do with the numbers being strings in your case. If you sort a string it is sorted like you describe. In order to sort it by it’s value you need to remove the $ sign and cast it to a number.

   Log in to Reply

4. Did you see this technique? – adding zero to the meta value of the to force it to be treated as an integer. The post has been updated various times over the years too so it might help you;

   http://wordpress.org/support/topic/order-by-meta_key-where-meta_value-is-number?replies=11

   Log in to Reply

5. function order($a, $b) {return intval($b) - intval($a);}
   uasort($array, 'order');
   

   I wonder that can help you 😉

   Log in to Reply