what you could do is: 1. get the list of all posts currently on the page 2. grab all the IDs of the posts 3. do the following query: SELECT DISTINCT meta_value FROM $wpdb->postmeta WHERE meta_key = ‘product_brand’ AND post_id IN (3,9,10,15) ORDER BY meta_value; where 3,9,10,15 are post ids that you’ve collected.
actually I managed to solve this differently (and more elegantly). However, even this new approach had me banging my head against the wall for way too many hours as my option table didn’t get updated properly, when doing a bulk delete of more than one category. Turns out I made two – glaring mistakes . … Read more
WP_Query is your friend. Combined with featured images, you should be able to do this as a page template with a WP_Query call and loop. This is the html for the top post at the moment: <li class=””> <a href=”http://dsi.sva.edu/cheryl-heller-named-in-top-100/”> <img src=”http://dsi.sva.edu/wp-content/uploads/2013/01/public-interest-design.jpg” width=”332px”> </a> <span><b><p style:=”” color:=”” #f15c25;=””><a href=”http://dsi.sva.edu/cheryl-heller-named-in-top-100/”>Cheryl Heller was named one of the … Read more
I assume that you would be providing the author IDs in the widget options. And that the authors would be displayed in the order they were listed. Assuming the input would be -> 3,10,12 You can have the following code to display the authors with that user ID in that order: $user_ids = “3,10,12”; //this … Read more
For this to work you need the date stored in the database to match the $todaysDate and it probably doesn’t. If I am reading your somewhat confusing question correctly then you are storing dates like 20th Jan 2013 but you are matching it against a date that looks like 0120 (January 20). Even if you … Read more
Check in your function to save the post meta data for the post type or better for $current_screen. The var is a global and return a object with different identifier to check, in which admin page init the function. Check in your function and return if is not the right $current_screen->id or post_type. Small hint: … Read more
Your current query will select posts that have a value in the key event_announced which does not equal on. What I think you want is NOT EXISTS, and you can omit value, since you are querying for posts that don’t have the key, hence, it will have no value. Note that NOT EXISTS is only … Read more
Here’s the code from the ACF Relationship Field example adapted to your field name. I edited out some of the markup just to simplify things. A couple of notes: Use a proper text editor and indent your code so it is readable. A soup of random indentation makes it much more difficult to debug code. … Read more
You are saving your extra fields to the *_options table so you need to pull them back out of that table. You can copy and cobble together bits of the existing code to do that. if ( is_category() ) { $current_cat = get_query_var(‘cat’); } $tag_extra_fields = get_option(MY_CATEGORY_FIELDS); // var_dump($tag_extra_fields); // debug if (isset($tag_extra_fields[$current_cat])) { var_dump($tag_extra_fields[$current_cat]); … Read more
I’m sure it’s possible, but will require some work with both PHP and jQuery. This plugin by Thomas Griffin to insert an image into a meta box would be a very good starting point. You’ll need to do some digging around in the js files in wp-admin/js and in wp-admin/includes/media.php.