meta_value_num sort glitch

You want natural order sorting, Example; $val = array(5.1, 5.11, 5.12, 5.2, 5.21); natsort($val); foreach ($val as $key => $val) { echo $val.”<br>”; } Produces: 5.1 5.2 5.11 5.12 5.21 Where as; $val = array(5.1, 5.11, 5.12, 5.2, 5.21); asort($val); foreach ($val as $key => $val) { echo $val.”<br>”; } Produces: 5.1 5.11 5.12 5.2 … Read more

little help with a mySQL query to wp database

Following the recomendations of @toscho i had a look at get_results and the following edits to the function ended up doing the trick. if ( ! function_exists( ‘get_meta_values’ ) ) { function get_meta_values( $key = ”, $type=”post”, $status=”publish” ) { global $wpdb; if( empty( $key ) ) return; $r = $wpdb->get_results($wpdb->prepare( ” SELECT pm.meta_value, pm.post_id … Read more

all tincymce’s switch when updating page after changing from html to text in custom metabox

This is, as you guessed, default behavior. It’s stored in the wp_usermeta table for each user in the wp_user-settings meta_key and does not differentiate between different editor instances. On a side note, the tinymce version of wp_edior() does not cooperate very well with being inside a meta box. Especially if the metabox is moved, or … Read more

Compare WP Custom Field date

Take a look at meta.php:777: … CAST($alias.meta_value AS {$meta_type}) {$meta_compare} {$meta_compare_string})… So if you want to use DATE comparisons, you should use MySQL compatible date formats (YYYY-MM-DD). Change this part of your code: array( ‘key’ => ‘date’, ‘value’ => date(“Y/m/d”), ‘compare’ => ‘>=’, ‘type’ => ‘DATE’ ), to: array( ‘key’ => ‘date’, ‘value’ => date(“Y-m-d”), … Read more

WordPress Custom Field Should be Unique. Is it possible?

You can use the filter hooks ‘add_post_metadata’ and ‘update_post_meta’, when a function hooked there return anything but NULL the process of adding/updating metadata is stopped. The two hooks passes almost same args: NULL post id the meta key the meta value being added/updated Only last argument is different, in case of update is previous value, … Read more