If you’re looking for raw SQL query, then this should help: UPDATE <PREFIX>postmeta SET meta_value=”temp4″ WHERE meta_value=”temp1″ AND meta_key = ‘post_template’ If you want to run this query from WP, then you can use this: global $wpdb; $wpdb->update( “{$wpdb->prefix}postmeta”, array( ‘meta_value’ => ‘temp4’ ), array( ‘meta_key’ => ‘post_template’, ‘meta_value’ => ‘temp1’ ) );
filter using custom fields
Is there a way to tell which country you are in when viewing the site? I mean like is the domain name example.uk | example.ca | example.com/en … That kinda thing? Then you could search your domain for the string for that country: $protocol = stripos($_SERVER[‘SERVER_PROTOCOL’],’https’) === true ? ‘https://’ : ‘http://’; $url = $protocol … Read more
Thank you everyone for your help! In the end the query below got me the results I desired – which was to show and sort the posts by a custom field of “publication_date” first – sorting by the date, and if there were multiple of the same date (say, 4 marked June 2013), it would … Read more
Problem with my loops
Add square brackets to input names to get PHP to interpret them as an array of data instead of overriding the value with each new input. so your input will look like this: <input type=”text” name=”skills[]” id=”skills” value=”<?php echo esc_attr( get_the_author_meta( ‘skills’, $current_user->ID ) ); ?>” class=”textbox” /> <input type=”text” name=”skills_percent[]” id=”skills_percent” value=”<?php echo esc_attr( … Read more
Show Custom field value instead of title in WP Menu
How are the custom fields saved? If you use ACF – Advanced custom fields, you can use get_field() function to get the variables. This should get you started. You can use another action hook or priority if you want the table to be displayed somewhere else. function display_product_table(){ global $product; ?> <table class=”shop_attributes”> <tr> <th><?php … Read more
Why does my numeric meta query work only on one meta key and not the other?
Custom Field URL + description