How about: $thumb = get_post_meta( $post_id, ‘thumb’, true ); $url = get_post_meta( $post_id, ‘website’, true); echo “<a href=”https://wordpress.stackexchange.com/questions/24970/$url”><img src=”$thumb” /></a>”; The get_post_meta() function is ideal when you know ahead-of-time the names of the fields you want to retrieve. Setting the third parameter to true tells it that you want to return a single value, and … Read more
I found this: http://codex.wordpress.org/Displaying_Posts_Using_a_Custom_Select_Query I have modified the date to retrieve the last 15 days. It’s untested, but should work. $expireDays=”15″; $querystr = ” SELECT $wpdb->posts.* FROM $wpdb->posts, $wpdb->postmeta WHERE $wpdb->posts.ID = $wpdb->postmeta.post_id AND $wpdb->posts.post_status=”publish” AND $wpdb->posts.post_type=”post” AND $wpdb->posts.post_date >= ( CURDATE() – INTERVAL $expireDays DAY ) ORDER BY $wpdb->posts.post_date DESC “; $pageposts = $wpdb->get_results($querystr, … Read more
The function, the_meta() allows you to hook to the the_meta_key filter (which currently is not documented in the Codex); this is where it fires off: // wp-includes/post-templates.php @line 744 echo apply_filters(‘the_meta_key’, “<li><span class=”post-meta-key”>$key:</span> $value</li>\n”, $key, $value); http://core.trac.wordpress.org/browser/tags/3.2.1/wp-includes/post-template.php#L735 This filter is applied to each and every meta pair, which means that you can add a filter … Read more
Assuming the rest works, why not order the normal way: function sort_posts_orderby( $orderby ) { $orderby = ‘wp_postmeta.meta_value ASC, wp_posts.post_date DESC’; return $orderby; }
I can’t tell here whether or not you have the WordPress API available to you. (Is this code that is being run from within an instance of WordPress, or is it being run by an external script on the WordPress database, without bootstrapping WordPress itself?) If you have the WordPress API, it is easy to … Read more
I don’t know if you’ve found an answer on this question yet since it’s from 2011 but I have an idea on how to retrieve the data. What if you created a VERY simple php file that took the post ID as a get variable and displayed the post’s custom fields? It would look something … Read more
You can use an custom plugin for your custom fields function fb_custom_search_where($where) { // put the custom fields into an array $customs = array(‘custom_field1’, ‘custom_field2’, ‘custom_field3’); foreach( $customs as $custom ) { $query .= ” OR (“; $query .= “( m.meta_key = ‘$custom’ )”; $query .= ” AND ( m.meta_value LIKE ‘{$n}{$term}{$n}’ )”; $query .= … Read more
Trying using WP_Query() using the meta_query arguments. Something like this: <?php $geotag_post_query_args = array( ‘meta_key’ => ‘latlng_readable’ ); $geotagged_posts = new WP_Query( $geotag_post_query_args ); ?> Now, $geotagged_posts is a query object, that should include all Posts that have the latlng_readable meta field. You can extract the $post data from this object the same as any … Read more
Definite solution: Seeing as wp’s core get_post_custom function returns multiple data fields saved as a single key in a random order, I resolved the issue by writing a function to replace it – which has some added flexibility: /*————————————————————— Function: Retrieve post meta field for a post based on ID Usage: [admin/meta_box/downloads.php] = to replace … Read more
I hope I understand the question correctly . When you move a post , the meta keys and values associated with it should remain with the post itself, like all post meta (including the attachments , custom-image etc..) – so there should be no problem to keep the values. Normally ,The only thing that SHOULD … Read more