What about using the UNION? Just an example: (SELECT * FROM $wpdb->posts (with JOIN and WHERE as needed)) UNION (SELECT * FROM $wpdb->posts (with WHERE to select pages)) GROUP BY/ORDER BY The select(s) must be in parenthesis to use an order by for the whole union result. As a second option, you can use a … Read more
You are passing strings as the second parameter $terms and you have a hierarchical taxonomy. Per the Codex: For hierarchical terms (such as categories), you must always pass the id rather than the term name to avoid confusion where there may be another child with the same name. If you follow the source, you will … Read more
Declare an array at the start of your layout, or in your functions file depending on the scope required and populate the array with all the bands using get_posts and making the key the post ID. You will then have a global array of bands, and can pull info from each one wherever you need … Read more
The way you query for Taxonomy is deprecated, see the reference in the Codex: http://codex.wordpress.org/Class_Reference/WP_Query#Category_Parameters So instead of ‘taxonomy’=> $taxonomy, you should use this: ‘tax_query’ => array( array( ‘taxonomy’ => $taxonomy, ‘field’ => ‘slug’, ‘terms’ => $section->slug ) ) And make sure that $taxonomy is defined!
Wrap your WP_Query object in a function so you don’t have to change all the query $args. The function will pass parameters for custom field value and order by custom field value. Here how you can do it: <?php function custom_query($divided_cf_val=array(), $order_by_cf_val) { ?> <div id=”listings”> <?php $args = array( ‘post_type’ => ‘listing’, ‘post_status’ => … Read more
You have some errors on how meta_query array is setted for price-max and price-min. Also in your code will be an issue if no $_GET[‘beds’] are sended but $_GET[‘price-min’] and $_GET[‘price-max’] are. this because the $args[‘meta_query’] array is setted inside if($_GET[‘beds’] >= 1). Moreover your code will throw a lot of notices if the GET … Read more
This is how I would approach it: Code function my_pseudo_date_query( $where, $query ) { global $wpdb; $dq = $query->get(‘my_date_query’); if( $dq && !empty( $dq[‘after’] ) ){ $where .= $wpdb->prepare( ” AND {$wpdb->posts}.post_date >= %s” $dq[‘after’] ); } if( $dq && !empty( $dq[‘before’] ) ){ $where .= $wpdb->prepare( ” AND {$wpdb->posts}.post_date <= %s”, $dq[‘before’] ); } … Read more
Yes, it is possible, WordPress does not have an API, but some useful functions. I would load all your rows into array like $your_table = [‘post_id’ => ‘image’, ‘post_id’ => ‘image’, …] Then execute a foreach loop foreach($your_table as $post_id => $image) { //full path to the image $image_path = _YOUR_FULL_ABSOLUTE_PATH.$image; /** * Get an … Read more
This is because you haven’t mentioned post_type here and by default post_type is ‘post’ and hence it is missing the pages, add the below in your query ‘post_type’ => array( ‘post’, ‘page’ ) Like this $articles = new WP_Query( array( ‘showposts’ => -1, ‘tag’ => $tag, ‘meta_key’ => ‘date’, ‘orderby’ => ‘meta_value_num’, ‘order’ => ‘DESC’, … Read more
I guess one could argue that this is somewhat wordpress related, because you are trying to get_results() from $wpdb, but like @MarkKaplun said your problem is that you are using the SQL wrong. Below code is an example on how to do it correct: $dr = $wpdb->get_results( $wpdb->prepare( “SELECT * FROM wp_shipping WHERE country = … Read more