I’m not an SQL expert, but I would think you might have to JOIN twice to pick two distinct rows out of wp_postmeta: $featuredquery = ” SELECT wposts.* FROM $wpdb->posts wposts JOIN $wpdb->postmeta article_level ON ( wposts.ID = article_level.post_id AND article_level.meta_key = ‘article_level’ ) JOIN $wpdb->postmeta article_genre ON ( wposts.ID = article_genre.post_id AND article_genre.meta_key = … Read more
It’s not a single step, but it’s easy to write & handle in code: get_post_custom() gives you all attached meta data. But be aware: Everything comes as array, even when it´s a single value. So // Ever entry comes like this. // Example single value for ‘Hair color’: Array( [0] => Array( ‘Brown’ ) )
You should check the urls in your Custom field. This function adding http for invalid url. function addhttp($url) { if (!preg_match(“~^(?:f|ht)tps?://~i”, $url)) { $url = “http://” . $url; } return $url; } And finally: <?php function addhttp($url) { if (!preg_match(“~^(?:f|ht)tps?://~i”, $url)) { $url = “http://” . $url; } return $url; } ?> <a href=”https://wordpress.stackexchange.com/questions/275288/<?php echo … Read more
In that case try to create custom sql query like this. global $wpdb; $query = “SELECT meta_value FROM wp_postmeta WHERE post_id=your post id AND meta_key=’class’; $results = $wpdb->get_row($query) ; echo $results->meta_value;
$wpdb class updating meta_value using Ajax [closed]
This appears to be a general PHP warning, you’re supplying an incorrect argument in a foreach loop. $_POST[‘list_id’] is expected to be an array or any other (iteratable object), when no checkboxes are checked I assume $_POST[‘list_id’] is completely undefined. $_POST[‘list_id’] = isset( $_POST[‘list_id’] ) ? (array) $_POST[‘list_id’] : array(); Adding this before you iterate … Read more
Decided going to use comments system to implement this feature.
This is what I ended up using, turned out I didn’t need to apply the meta value to the child pages since I used another approach. Hopefully it’s useful for someone. $row = $wpdb->get_row(“SELECT * FROM wp_posts WHERE ID =’$post_id'”); $new_order = $order[$page[‘depth’]]; $new_order = $wpdb->escape($new_order); $current_order = $row->menu_order; if($current_order != $new_order) { switch ($new_order) … Read more
global $wpdb; /* grab meta value, it is assumed you know the post id ($id) in question */ $dot_number = get_post_meta( $id, ‘dot_number’, true ); /* grab all rows with matching value in ‘dot_number’ column */ $matches_query = $wpdb->get_results( “SELECT * FROM ” . $wpdb->prefix . “csadata ” . “WHERE dot_number = ” . $dot_number, … Read more
Editing does not change post_name