I think something like this, but not tested, and my SQL-foo is rather weak: $test = $wpdb->get_col( $wpdb->prepare( ” SELECT DISTINCT $wpdb->posts.* FROM $wpdb->posts INNER JOIN $wpdb->postmeta AS mt1 ON ( wp_posts.ID = $wpdb->postmeta.post_id ) WHERE $wpdb->postmeta.meta_key = ‘goals-made’ AND( mt1.meta_key = ‘goals-against’ AND CAST($wpdb->postmeta.meta_value AS INT) > CAST(mt1.meta_value AS INT) ) ” )); This … Read more
Development of Pods 2.0 definitely won’t stop, the funding problems explained in that dev post were alluding to an upcoming announcement that we’ll be pushing some of the enterprise and “extra” functionality of Pods 2.0 into a premium version targeted towards firms with more advanced and specific needs. On the data structure, Pods 2.0 handles … Read more
Maybe you’re using the wrong tool to represent relations between posts. the custom post meta fields api is somehow inefficient for that task and has certain restrictions. I advice to have a look at the “posts to posts” plugin from pipin which is much more suited for that task.
I’ve ruled out this being an issue with Advanced Custom Fields, so I’ve made a new question. For more information, please look at: wp_get_attachment_image_src multisite issue
How to get_terms() only of terms matching an ACF meta value?
I see your problem in the javascript. I’ve done something similar using the “on close” event of the wp.media object. You can use the “select event”, as you are actually doing, but I would use “on select” event mainly for events within the modal window (but it is just preference, you can use the “on … Read more
As far as I know the custom key-value pairs are kept in the wp_postmeta table. You can simply examine (and delete) them in the database directly. SELECT * FROM wp_postmeta WHERE meta_key LIKE ‘%you_old_key_name%’ The ACF configuration of the fields is another story, but you say that you don’t even have the field in the … Read more
The code doesn’t seem syntactical wrong in the first place. What kind of field type are you using? Relationship? Also why are you overriding $post_object and where does it come from in the first place? That part of the code is missing. To get the field which is attached to the current post (inside the … Read more
There’s a lot going on here. First off, you should store the repeater field image as an ID (that probably requires changing how the subfield’s setting and possibly re-uploading some of your images) and then use all the WordPress Core API functions to handle it. (You’ll probably cross paths with wp_get_attachment_image_src.) That gets rid of … Read more
Can you put the following code for displaying content of custom filed? <?php the_field(‘filed_name’); ?>