A generic term referring to the process of retrieving information from a database.

learn more… | top users | synonyms

5
votes
1answer
643 views

How to organize and cache additional data associated with terms?

I'm updating a plugin of mine and am have a hard time figuring out the "best way" to build in a specific bit of functionality. The plugin allows users to associate images from their media library to ...
2
votes
1answer
522 views

Plugin similar to Taxonomy Drill-Down for custom fields?

Is there a plugin available that does for custom fields what Scribu's excellent Taxonomy Drill-Down (formerly called Query Multiple Taxonomies) does for taxonomies?
0
votes
1answer
2k views

How to get category/tag in URL for Pagination links?

I have a custom pagination function in functions.php. If I'm at the URL: http://mysite.com/tag/dogs, the Next link currently just contains /page/2. How can I make it so it will look like /tag/dogs/...
0
votes
1answer
201 views

How to “orderby” the first array in a meta_query that uses multiply keys?

My query is currently sorting by end date. How can I make it so it will sort by the start date? $args = array ('post_type' => 'events', 'meta_query' => array( ...
5
votes
2answers
2k views

Usage of the new “posts_clauses” filter in Wordpress 3.1?

Just noticed that 3.1 added a new filter to customize queries: posts_clauses. All I could find about it is that instead of using the separate query filters like posts_where or posts_join, you can ...
0
votes
2answers
749 views

Wordpress Custom Query: Combining Two Functions

I'm a bit new to php and am having some trouble combining the functionality of two custom queries in Wordpress in order to (1) get pagination to work properly, and (2) sort my posts according to a ...
1
vote
3answers
235 views

Huge amount of queries on my site

My site is reaching CPU limits all the time, I just ran Debug Queries and got more than 4000 queries, no wonder site is slow.
0
votes
2answers
162 views

custom post-type query just returns two posts

I'm making a custom activity calendar for a client here: http://arbeidshesten.com/aktivitetskalender/ The backend is a custom post type "aktiviteter", with custom fields for the date ("dato") and ...
0
votes
1answer
486 views

How Can I Always Display A Particular Post First Using WP_Query?

My apologies if this question has already been asked somewhere else, I searched but couldn't find anything. I am working on a tours website, there will be individual package pages that show some text, ...
0
votes
1answer
2k views

Query multiple taxonomy in Custom Post Type

Currently I use: query_posts("post_type=listing"); to pull all entries of my custom post type. But I have a taxonomy called status with the values of Available, Pending, Sold. I only want to show ...
0
votes
1answer
172 views

Problem on displaying the results on my query

Hello this is my query. I want to show the titles of posts that have fullfil the following but it doesn't show anything, I don't know. Thank you! Also, is there another way to show the results, more ...
0
votes
1answer
223 views

Loops for cat links not looping for wordpress site

I have this code and all the vars pull in but the latest news is not showing up and the subscribe link is not dropping anything. any ideas? Everything else works like a charm. <div class="...
0
votes
2answers
4k views

wp_query orderby title and meta key value (WP3.1)

I have a taxonomy wp_query and i would like to order the list by title and by meta value (numeric value) Have a meta value Interesting = 1 or 0 in the posts Not so interesting posts would be at the ...
2
votes
1answer
1k views

[Plugin: Posts 2 Posts] How does it work?

I recently discovered Scribu's Posts 2 Posts plugin, which seems to be exactly what I was looking for in order to connect pages and posts for a big editorial website. But I cannot get it to work, ...
0
votes
1answer
95 views

Number of posts in the archive

How do I show 10 posts on the first page of the archive, and 20 on others (>1)? My custom post type name is "apartments". Cheers!
1
vote
2answers
813 views

get_the_category and echo out link to child-most/deepest category

I have this code which is located on the search.php page and retrieves all the categories for each post and echo's out a link to the first category: $category = get_the_category(); //print_r($...
3
votes
1answer
197 views

How to make an activities stream mixing posts and comments?

What I'm currently trying to make is an activities stream wich list : The posts, the comments, both mixed between them and ordered by date. My idea is to make two queries, but i don't know how to ...
1
vote
2answers
3k views

Wordpress Orderby Numeric Value Not Working

I am trying to get all products from the wpsc-product post type and then display them by a custom meta field called release_date_year. However, it doesn't appear to be ordering my posts by this custom ...
0
votes
2answers
3k views

Use mysql_query instead of $wpdb query

I have a custom table inside my wordpress database called test. What if i query this table using mysql_query() instead of using for example $wpdb->get_results() Will this affect my performance? Ty ...
0
votes
1answer
367 views

Prioritising and Ordering Posts By Category Name Using A Custom Loop

I have a custom loop pulling out videos all assigned to various categories. However there is a category called "new-video" and I need to pull out all videos using my custom loop, but I would like the ...
0
votes
1answer
641 views

Display Post by taxonomy and taxonomy child

This is a follow up to Display Post by taxonomy and taxonomy child if exist I need to display a list of Accomodation, first by Type of Accomodation, then by Regions. I have a post-type, called ...
1
vote
3answers
2k views

only show container with next/prev links if they exist?

hey guys, i know there is something like if ( function_exists('') is it possible to use that with next_posts_link() and previous_posts_link(). The reason I'm asking that is that I have something ...
1
vote
2answers
3k views

Adding Variables to post query

How do I add custom variables to the wordpress query without having to hit the database twice. In the example below I want to add some meta filters. All this code works fine but I have been running ...
1
vote
3answers
1k views

Possible to filter the posts or categories that XML-RPC users see in their mobile application?

Is it possible to filter the posts or categories that XML-RPC users see in their mobile application? I have a plugin that hooks into pre_get_posts and list_terms_exclusions to do what I need it to do....
0
votes
3answers
324 views

And/Or Category Query

I'm having a lot of trouble using php query_posts(array('category__and'=>array(1,3))) - it seems to be pulling anything that's in category 1 regardless of whether it's also in category 3 and I only ...
7
votes
4answers
37k views

Proper way to get page content

I have to get specific page content (like page(12)) I used that : <?php $id=47; $post = get_page($id); echo $post->post_content; ?> Work nice execpt for compatibility with qtranslate ...
0
votes
1answer
474 views

Query the Loop without breaking it

Im trying to make different querys in my category like one with a offset of post and one that shows one post but while it continues to go through the loop, this is what i have but the loop keeps ...
0
votes
1answer
33 views

Is there a (preferable built-in) way to check what custom queries are used in a theme?

I've build a theme using custom post-types with queries like $my_custom_post_type_query = new WP_Query( array( 'my_arg' => 'value' )); Now I'm writing a plugin where I need to do something like ...
0
votes
1answer
473 views

Can I query posts by taxonomy conditionally based on post type?

I have a query based on multiple post_types and taxonomies that works well, however I would like to add a level of complexity and query a taxonomy only for a specific taxonomy. This query works as ...
0
votes
1answer
880 views

Wordpress: paginating array using a foreach

I currently grab an array of user data from a query. I then use a foreach to loop through them and apply styles and divs to output them to the page. This all works great but i would like to paginate ...
1
vote
3answers
4k views

mysql query two database tables, users and usermeta and sort by custom meta int value

I am trying to get an array of site users sorted by a custom meta value (an int). I can query the users just fine and get them back to use in a foreach. I currently have the query results come back ...
1
vote
2answers
724 views

query_posts() ALWAYS displays something?

OK, I'm using posts_query() to display posts. The problem is, at least in my case, posts_query() always outputs something. For example: <?php $paged = (get_query_var('paged')) ? ...
0
votes
2answers
2k views

Multiple Category Query

Is it possible to display a wordpress category page but have it pull posts from mulitple categories? For example, let's say I need to pass in params for cat_id in this fashion /category/dining/?...
0
votes
1answer
1k views

Custom Permalinks Break Search Pagination

So I'm having a weird issue that I've never seen. I have a search.php set up like this: $paged = (get_query_var('paged')) ? get_query_var('paged') : 1; query_posts($query_string . '&paged=' . $...
1
vote
1answer
452 views

Disallow categories from this MySQL query

I'm trying to modify a plugin that generates an archive listing so it shows only one category, making it a single category archive. The old version of the plugin used a get_posts query, and so it was ...
1
vote
1answer
58 views

Listing posts by grouping dates

I have a music events site http://www.zarpa.eu. I'm using the Future is Now plugin to help me to schedule the events http://wordpress.org/extend/plugins/the-future-is-now/ I'm trying to group ...
0
votes
1answer
143 views

Page displays content from different query?

How can I reset all variables in order to get the actual page content? I keep getting the last post's content I've called from a news-box I've implemented - but need the actual page's content .. ...
1
vote
2answers
6k views

Does meta_query work within get_posts array?

I can't seem to get this to work — I'm trying to show posts that have the meta 'featured_image' value set to anything. From what I can tell, it's set up correctly, but I'm in a little over my head. ...
0
votes
3answers
783 views

Each post is showing twice in my custom query…?

I've created a custom query to pull all posts from a custom post type, ordered by comment count. It's your run-of-the-mills custom query: <?php $querystr = " SELECT wposts.* FROM $wpdb-...
1
vote
4answers
5k views

Export wordpress table to excel

I have created PHP scripts before to export a database table to .xls format like this: $select = "SELECT * FROM tracking"; $export = mysql_query ( $select ) or die ( "Sql error : " . mysql_error( ) )...
1
vote
2answers
1k views

Count how many posts have a custom field set

I've added some code to my templates which automatically adds custom fields to cache some data that each post pulls in. Is there a way that I can track how many posts have had this custom field set?
1
vote
2answers
976 views

Selecting New & Edit Page for Custom Post Types

I'm probably missing something unless it's really not possible, for some reason I can't get my function to only execute on the new and edit page of a custom post type (the new not being a problem): I'...
0
votes
3answers
971 views

How to find if a post with custom_field == X exists?

I need to find if a post with a custom field X equal to Y exists in a wordpress installation. Should I do it with a simple sql query or is there something build in that can help me achieve it?
2
votes
3answers
4k views

Custom Select Query with Custom Post Types

Have been trying to figure out the issue with this for the past hour, but hitting a wall. Basically I'm just trying to query my custom post type based on some custom date fields and then displaying ...
-1
votes
1answer
1k views

WP insert post PHP function dynamically generated Custom Fields

Further to my previous question WP insert post PHP function and Custom Fields We have a working insert post function that can also send over custom fields without yet knowing the ID. Please see the ...
4
votes
3answers
3k views

Optimize Multiple Taxonomy Term MySQL Query?

(Moderator's note: Title was originally: "query/database optimisation") I'm written a function for a custom "filter" search panel that allows users to select terms from up to four custom taxonomies. ...
0
votes
1answer
1k views

Query of custom post types only shows first post

I have a loop to show my custom post type of 'case_studies'. It originally showed all posts until I wanted to just show 3 specific posts. The problem is that it only shows the first post in my list of ...
0
votes
1answer
431 views

Custom query for custom post_type

I need to display a list of current tasks. Each task has a custom post_type and a start date and end date. Can someone tell me how to modify my query so it will pick up any tasks that have a start ...
0
votes
1answer
153 views

pre saved posts query from db options table

I found a question about magazine style front pages that queries always only 1 post (or custom_post_types, etc.) from a whole load of different categories, tags or custom taxonomies. I thought about ...
0
votes
2answers
345 views

How to get events using multiple custom meta fields?

I need to grab a list of current events. The events have a start and end date so I need to be able to select a range as opposed to just getting any list of events that have an end date that is after ...