I always find it way less confusing to get the results from one table and loop them rather than to try to join them like that… eg. global $wpdb; $query = “SELECT post_id FROM wp_postmeta WHERE meta_key=’fake_author’ AND meta_value=”11111″”; $results = $wpdb->get_results($query); foreach ($results as $result) { $query = “UPDATE wp_posts SET post_author=”222222″ WHERE ID='”.$result->post_id.”‘”; … Read more
Filter multiple custom fields Values with Check boxes
You do not verify the nonce correctly. Try this, it should work: //1. verifies meta box nonce (to prevent CSRF attacks) if( !isset( $_POST[‘work_meta_box_nonce’] ) || !wp_verify_nonce( $_POST[‘work_meta_box_nonce’], basename( __FILE__ ) ) ){ return; } For more info on wp_verify_nonce see here.
Button inside Custom Meta Box triggering the Update Button
Change the sort order for posts to include custom field
Turns out Advanced Custom Fields, a plugin I was already using, makes it super easy to insert additional fields into the comment form. ACF is so good that it has created a tutorial to do just this and how to output the data within the comment thread: https://www.advancedcustomfields.com/resources/get-values-comment/ However, by doing this the plugin adds … Read more
The comment from @czerspalace put me on the right track to doing what I needed. Since the first few terms start with numbers, this is how I implemented my solution: // get results from $wpdb in object called $links $glossary_ltr = “999”; foreach( $links as $link ) { $kw_ltr = substr( $link->keyword, 0, 1 ); … Read more
Merge Multiple Custom Fields into one New Custom Field for Searching
Trying to update_post_meta function
Hope this below SQL query will solve your problem- INSERT INTO wp_postmeta (post_id, meta_key, meta_value) (SELECT post_id, ‘tnid’, meta_value FROM wp_postmeta WHERE meta_key = ‘name’ AND post_id IN (SELECT id FROM wp_posts WHERE post_type LIKE ‘post’)) Please try it first. I haven’t got the chance to try it.