So if i understand you correctly, you want to sort by a value that has to be calculated based on the currency? You can do this, but not within a wordpress wp_query of sorts. Instead you can do one of two things: Method 1: The “do more now, have less hassle later”-way: On saving the … Read more
You’re missing an s. $query->set(‘posts_per_page’, ‘1’); However – you probably don’t want to do this for every query, since that affects everything – widgets, back end, everything. You should make it conditional. For example: <?php function university_adjust_queries($query) { // If this is the main query, not in wp-admin, and this is the homepage if($query->is_main_query() && … Read more
I’m hitting the table 2 times (if the field exists) to get its value. No, you aren’t, and there is no evidence for this. You may not be hitting the database at all if it has autoload enabled. WordPress caches things in memory during the same request, and it bulk fetches options set to autoload … Read more
There is really no reason to use raw sql to query posts. You can accomplish just about any type of query using the WordPress API. For full reference see the codex, Function Reference query posts. Try the following: global $post; $args=array( ‘post_type’ => ‘tutorial’, ‘orderby’ => ‘comment_count’, ‘posts_per_page’ => 10 ); $posts= query_posts($args); foreach ($posts … Read more
Yes, it is. You’ll need a template page for the category (for example, category-30.php, where 30 is the id of the category you want to show with multiple subcategories). In the template, run through the standard loop for post from the original category if you want to, if not, the magic function will be wp_reset_query … Read more
The posts_where filters the ‘WHERE’ part of the SQL statement, and not the query string. So $where .= “&post_date > ‘”.date(‘Y-m-d H:i:s’, strtotime(‘-24 hours’)).”‘”; should be $where .= ” AND post_date > ‘”.date(‘Y-m-d H:i:s’, strtotime(‘-24 hours’)).”‘”; Also as this hook is fired for every query (admin and public side), you should use some logic to … Read more
First make the custom post query with the WP_Query, and then we get the metadata by get_post_meta. Checkboxses are saved as boolean, that means either true or false. So make a check in the loop if checked or not (1=true, 0=false). <?php get_header(); ?> <?php // The Query $the_query = new WP_Query( array( ‘post_type’ => … Read more
Ok so hope this helps someone. Unless you want to query the database directly, the trick is to include the following: $event = Ai1ec_Events_Helper::get_event($post->ID); thereafter you can retrieve the variables, for example: <?php query_posts(‘post_type=ai1ec_event’);?> <?php while ( have_posts() ) : the_post(); ?> <?php $event = Ai1ec_Events_Helper::get_event($post->ID); ?> <?php echo ‘<h5><a href=”‘.get_permalink().'”>’.get_the_title().'</a></h5>’; ?> <?php if( $event->multiday … Read more
Hey use this to grab all users excluding users with ID – 1,2,4 $blogusers = get_users(array(‘exclude’ => array(1,2,4))); Note – The function get_users_of_blog() is depricated, so it’d be good idea to use get_users() function which supports excludeing of users by their IDs.
Your title is wp_get_post_terms Order by not working but if you use a custom post type you need to use wp_get_object_terms() I’m not sure what your aim is, but here is a code example you can try: $my_post_type=”post”; // edit this $my_taxonomy=”category”; // edit this $my_query = new WP_Query(array(‘post_type’ => $my_post_type,’posts_per_page’=>10)); if ($my_query->have_posts()) : while … Read more