query - Read For Learn

Check if values exists DB

When should you use WP_Query vs query_posts() vs get_posts()?

query_posts() is overly simplistic and a problematic way to modify the main query of a page by replacing it with new instance of the query. It is inefficient (re-runs SQL queries) and will outright fail in some circumstances (especially often when dealing with posts pagination). Any modern WP code should use more reliable methods, like … Read more

very slow wordpress query with default query

Pagination not working with WP_Query (creates links but no page)

wp_pagenavi( array( ‘query’ => $wp_query ) ); change to wp_pagenavi($wp_query); I think that $wp_query is the variable that you define! That is the thing you will need to insert! Sometimes, you will need to pass $wp_query->max_num_pages depend on your custom query request

Custom taxonomy – query returns an error

Resetting permalinks, as per this thread, fixed this problem. Visit Settings -> Permalinks -> Save current settings

How to fix pagination for custom loops?

The Problem By default, in any given context, WordPress uses the main query to determine pagination. The main query object is stored in the $wp_query global, which is also used to output the main query loop: if ( have_posts() ) : while ( have_posts() ) : the_post(); When you use a custom query, you create … Read more

Removing a post from the results of a WP Query

Do you know the ID of the posts? Have you passed post__not_in as part of your query? $query = new WP_Query( array( ‘post_type’ => ‘post’, ‘post__not_in’ => array( 2, 5, 12, 14, 20 ) ) ); From: http://codex.wordpress.org/Class_Reference/WP_Query. The above will return all posts but exclude the IDs specified. Or do you have another way … Read more

Need help setting up a search form for wordpress [duplicate]

I know you asked for no plugin suggestion but I thought I’d share the solution I commonly use for creating advanced search forms in WordPress. http://wpadvancedsearch.com/ This is not a plugin but a PHP framework for building advanced search forms in WordPress. It has served me especially well with custom post types and creating search … Read more

Pulling values from a sepcific row in table

$leader_result = $wpdb->get_results(“SELECT user_first_name, user_last_name FROM “.$wpdb->prefix.”mro_attendees WHERE event_id = “.$project_id.” AND user_role=”team_leader” LIMIT 0,1″) foreach($leader_result as $row=>$value) { echo $value->column_name; }

Slow query when joining wp_posts with a lookup-table?

It’s the order of your primary key declaration. If you’re always searching on place_id, declare that first, then post_id: PRIMARY KEY (place_id, post_id)

+ More