Ok, I got there at the end. I couldn’t use WP_Query class as I really needed to have my own pretty big and complex SQL. Here is what I ended up having: In functions.php I have my custom SQL and logic for counting the values needed for the WP pagination logic: function vacancies_current( ){ global … Read more
Excellent responses on WP Hackers: http://lists.automattic.com/pipermail/wp-hackers/2012-June/043213.html What you’re doing with that query, is loading EVERY matching post into memory, including the full post contents. As you can imagine, this is probably quite a lot of items. You can pass ‘fields’ => ‘ids’ into WP_Query to simply return a list of matching post_ids instead, which should … Read more
Unfortunately you cannot perform a meta_query using a LIKE comparison on the meta_key value when using WP_Query. I’ve been down this road… Instead you have a couple other options if you want to maintain like status relationships as post meta and not user meta and or meta in a custom table. Option 1 requires no … Read more
Query all post titles of a specific post type // Function that returns post titles from specific post type as form select element // returns null if found no results. function output_projects_list() { global $wpdb; $custom_post_type=”page”; // define your custom post type slug here // A sql query to return all post titles $results = … Read more
Yes, it can be done. The key is to make the format parameter different for the two queries: <!– Cats –> <div class=”animals”> <? $paged1 = isset( $_GET[‘paged1’] ) ? (int) $_GET[‘paged1’] : 1; $paged2 = isset( $_GET[‘paged2’] ) ? (int) $_GET[‘paged2’] : 1; // Custom Loop with Pagination 1 // http://codex.wordpress.org/Class_Reference/WP_Query#Usage $args1 = array( … Read more
That’s question is only relevant, because WordPress use a mix from a coding language and layout language. If you would use a template language, syntax, than is this topic not relevant. But to your question. If you use your example source for a Theme, much more layout language like html, then I prefer the first … Read more
You should be able to call posts with a featured image with the following code: $thumbs = array( ‘posts_per_page’ => 5, ‘meta_query’ => array(array(‘key’ => ‘_thumbnail_id’)) ); $query = new WP_Query($thumbs); The code checks each post for the custom field _thumbnail_id, which is where the thumbnail image is stored.
In retrospect, I’ve did a mashup of MikeSchinkel and t31os suggestion. It’s possible to inject that to existing queries on the fly, but it needs WordPress 3.1: Plugin to get an RSS Feed for posts containing any term from a taxonomy.
This can be done by using the term_taxonomy_id rather than the slug, which will effectively ignore whichever taxonomy is specified and just look at the unique term_taxonomy_id field. This will allow you to effectively be able to do a mixed relationship. You’d want to use an overall relation of AND and put all the terms … Read more
I’m afraid that you can’t do it this way. wp_redirect is a fancy way to send header Location and the second argument of this function is request status, and not custom variable. (404, 301, 302, and so on). You can send some variables as get parameters. So you can do something like this: if ( … Read more