As I commented, if the meta value is a serialized string of an array like array( ‘Melbourne’, ‘Sydney’ ), then ‘value’ => ‘”(Melbourne|Sydney)”‘, ‘compare’ => ‘REGEXP’ would work. So there’s no need for a complex regular expression pattern, and your meta_query could look like so where $locations is an array of locations: ‘meta_query’ => array( … Read more
You should probably check out pre_post_update. Use pre_post_update to check for a post update within your custom post type Container of Things. Check for your conditions. Then, get the connected Things and use wp_update_post to unpublish these posts.
serialised PHP has security risks and can cause problems during search replaces if you change the length of values The argument for the serialised array is that it only fills ‘one space’ in the database as opposed to multiple rows but it sounds like it is difficult to perform WP_QUERY on a serialised array and … Read more
There is no need to juggle $wp_query object, store it in temp, etc. It is rarely good idea to directly mess with important global variables, unless you absolutely need to. You can just create your own arbitrary variable and init it with new WP_query $some_variable = new WP_Query($args); and so on. Also don’t forget to … Read more
The following code worked. <?php $feat_art = new WP_Query(array(‘post_type’ => ‘sp_events’,’sp_events_cat’=> ‘eventcat1′,’post_status’ => ‘publish’,’posts_per_page’ => 1)); while($feat_art->have_posts()) : $feat_art->the_post(); ?>
If you’re familiar with ZF you might be looking for models and layouts, both which you need to manually code with WordPress. But if you do so, you’ve got full possibilities. So feel free to create multiple template files and load them when it’s needed (e.g by hooking into template redirect or get_template_part) and then … Read more
t31os says: [See edit history for previous code and comments] Using Ajax to paginate your queries I’ve put together some code that will fetch your posts and comments via ajax using simple prev/next navigation via ajax. 1) Replace all the code you posted in your author.php with the following.. <?php $cat_settings = array( ‘Articles’ => … Read more
No need to have two queries, you can just reuse the same post data by resetting the current post position and running the loop again: $wp_query->current_post = 2; you’d have to do this twice to achieve what you’re asking, and stop it the second time at the third post.
The code you have provided already has a check to see if posts exist for said query. So all you need to do is expand on it. … <?php else: ?> <p>There is no news related to this theme</p> <?php endif; ?> … Simply place you next query posts in the above code replacing <p>There … Read more
Don’t serialize the search value, just use ‘value’ => ‘2011-09-16’ ‘compare’ => ‘LIKE’. Otherwise you’re essentially looking for; a:1:{i:0;s:10:”2011-09-16″} Which of course doesn’t actually match anywhere in; a:2:{i:0;s:10:”2011-09-16″;i:1;s:10:”2011-09-17″;}