This will work fine. global $wpdb; $querydetails = ” SELECT wposts.* FROM $wpdb->posts AS wposts INNER JOIN $wpdb->postmeta AS wpostmeta ON wposts.ID = wpostmeta.post_id WHERE wposts.post_status=”publish” AND wposts.post_type=”match_report” AND wpostmeta.meta_key = ‘report_home-select’ AND wpostmeta.meta_value=”198″ “; $teaminfo = $wpdb->get_results($querydetails, OBJECT); Try it.
<?php if(strlen(get_post_meta($post->ID, ‘recent_action’, true)) !== 0){ ?> <a class=”button” href=”https://wordpress.stackexchange.com/questions/107002/<?php echo get_post_meta($post->ID,”recent_action”, true); ?>”>Recent Action Link</a> <?php } elseif(strlen(get_post_meta($post->ID, ‘related_link’, true)) !== 0){ ?> <a class=”button” href=”https://wordpress.stackexchange.com/questions/107002/<?php echo get_post_meta($post->ID,”related_link”, true); ?>”>Related Link</a> <?php } elseif(strlen(get_post_meta($post->ID, ‘imp_docs_link’, true)) !== 0){ ?> <a class=”button” href=”https://wordpress.stackexchange.com/questions/107002/<?php echo get_post_meta($post->ID,”imp_docs_link”, true); ?>”>Important Documents Link</a> <?php } ?> or better yet … Read more
Get value from post meta array, and add it as a category
<?php $args = array(‘post_type’=>’products’,’posts_per_page’=>10,’number_posts’=>10); $products = get_posts($args); foreach($products as $product) { $productid = $product->ID; echo $producttitle = $product->post_title; echo $productdescription = $product->post_content; echo get_post_meta($productid ,’price’, TRUE); echo get_post_meta($productid ,’product_name’, TRUE); echo get_post_meta($productid ,’size’, TRUE); } ?> if the value is empty it shows null otherwise
Maybe it can be solved at run-time. wp_get_attachment_image says: Returns an HTML image element representing an attachment file, if there is any, otherwise an empty string. So, if the post meta is set, but an empty string is given, we should delete the post meta. $default=”<img src=”” . get_stylesheet_directory_uri() . ‘/img/team-logo.png” />’; if ( get_post_meta( … Read more
How to create a link for wordpress meta datas?
wordress core and importer has no way to know how any of the data is actually being used. The importer will just import everything, if a meta data stopped being used then you will get some not needed stuf in your DB but nothing worse then that. Of course it is very easy to test, … Read more
As @s_ha_dum has stated, your syntax mixes JS and PHP; and Ajax wil be needed. I’ll try to point you in the correct direction. This should be your javascript: jQuery(document).ready(function($) { $(‘button#rsvp_button’).click(function qwe4_tracker(){ var data = { action: ‘my_action’ }; $.post(ajaxurl, data, function(response) { //alert(‘Got this from the server: ‘ + response); // Uncomment to … Read more
I think you can do the trick running 2 loops, in the first you prepare an helper array of posts ordered by date, in the second you display this array: Something like this (completely untested): if ( $agenda_query_full->have_posts() ) { $date_events = array(); // helper array $today = date(‘Y-m-d’); while ( $agenda_query_full->have_posts() ) { $agenda_query_full->the_post(); … Read more
When you upload an attachment from the post edit screen, WordPress set the current post ID as the post_parent of the attachment. And that’s how you get these attachments: $post_ID = 123; $attachments = get_posts( array( ‘post_type’ => ‘attachment’, ‘post_status’ => ‘inherit’, ‘post_parent’ => $post_ID, ‘post_per_page’ => -1, ‘post_mime_type’ => ‘image/*’ ) ); foreach ( … Read more