A generic term referring to the process of retrieving information from a database.
1
vote
2answers
489 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')) ? ...
1
vote
2answers
577 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
1answer
49 views
using post__in allow duplicate post id
I have an array of ids in a specific order. I use post__in in my query to get posts from this array. I have some duplicate post IDs that I need to show twice in the page but the query seems to ignore ...
1
vote
2answers
65 views
Query reset problem or flawed code to enable custom post type query
After reading through here and trying various options, I am finally able to get my custom post types 'testimonial' (created with product 'Toolset') to show along with my standard cat/tag queries ...
1
vote
1answer
179 views
Get parse_query filter to return slug instead of id
After much headache in the last week I feel like my problem is almost solved. I have been attempting to customize the admin edit.php page of custom post types to display and sort/filter custom ...
1
vote
1answer
72 views
Add post_type to index.php
I search for an hour now without result. Does anyone can explain me how to show my custom post_type (dictionnaire) in the homepage (index.php). I use 'Easy post type' to add custom post types and I ...
1
vote
1answer
63 views
how would I create a custom query to get all users, and a related post based on a postmeta field?
I have about 50 users. Its pretty easy to list them all. However they are related to a special custom post type through a postmeta field called wpp_agents.
So I need to list Users, but also the ...
1
vote
1answer
150 views
Get Metakey value while saving post
I am trying to insert metakey value while saving or updating post but somehow it is not inserting metavalue to link column of my custom talbe called wp_banner_views
function ...
1
vote
1answer
60 views
Most liked page not displaying posts
I was looking for a post rating system for a while, then I stumbled across a great tutorial:
http://wp.tutsplus.com/tutorials/how-to-create-a-simple-post-rating-system-with-wordpress-and-jquery/
I ...
1
vote
1answer
494 views
Use get_post_types to query only custom posts types
I need to query only custom posts types - that is all post types in my WP install excluding posts and pages. I have used get_post_types to build a string of all custom post types which I want to ...
1
vote
1answer
76 views
Sort query by author: 1 author, then others
I have a post type called 'article' and on the article archive page i'd like to show all the articles, sorted by author.
function kia_adjust_the_query( $query ) {
// change posts_per_page ...
1
vote
3answers
1k views
$query->query_var['post_type'] not set for pages
Bulding off of this response from @kaiser about being able to filter by post types on a search page, I wanted to be able to automatically add-in all of the public post types available. So, after some ...
1
vote
1answer
77 views
Get the timout value of a saved transient?
Does anyone know if there is a Wordpress function to get the timeout value of a saved transient? I am using a transient with a 5 minute timeout to cache data from a web API call locally. Between ...
1
vote
2answers
148 views
Wordpress - query 5 posts with a specific post in top
Many searches and tests but in vain, I need an expert to rescue me.
I need a custom post query in worpdress, which returns only 5 posts starting from a specific post. In other terms, there is a div ...
1
vote
1answer
535 views
Show only oldest post by author
I am working with a heavily customized install of WP. I've set up a specific post type, taxonomy, and roles that gets to use just that post type.
Ideally, I'd like to restrict members of that role ...
1
vote
2answers
86 views
Querying both pages and posts
I am building an "advent calendar" for a client and they are wanting a combination of specific pages and custom posts appearing on the front page, in a specific order.
Things that need to be ...
1
vote
1answer
276 views
Exclude featured image and custom field from this get_attachment query
Is there a way I can exclude the post thumbnail AND a custom field with the value "_lm_comm_logo" from this query that pulls all of the images associated with a particular post?
<?php $args = ...
1
vote
1answer
701 views
Query & Sort Comments by custom comment meta
I added a basic "favorite/recommend" functionality for posts and comments to a wordpress site I'm working on.
I'm storing the total numbers of comment "likes" in a custom comment meta field ...
1
vote
1answer
474 views
Custom Query num_rows returns wrong amount
So I have a custom query that fetches all posts in a given category. I am trying to get the number of rows returned but it is giving me the wrong number.
Instead of 11, I am getting 14. Does anyone ...
1
vote
1answer
390 views
Is it possible to have pagination with an offset loop?
I am developing a blog page that requires 3 different post styles (Ie; one full page width with featured image and content, one full page width without featured image and the rest are half page width) ...
1
vote
1answer
492 views
Wordpress Search Filter Only for Page with Child of Child of Child of Child of Child
after browsing question from this site I found the workaround for this:
function SearchFilter($query) {
if ($query->is_search) {
global $post;
$query->set( 'post_parent', 21 ...
1
vote
3answers
170 views
query in category.php repeats itself
I'm need some help on my query.
I'm building up a category page where on top a post need to show where custom field key 'uitleg' has value 'ja'. Per category there is only one post with that value. ...
1
vote
1answer
692 views
Using ajax with paging and a custom sub-query
I have a page that uses three queries to retrieve a variety of content. One of those queries grabs posts that are related to the topic of the page. Since these posts can be of all sorts and related ...
1
vote
1answer
1k views
Wordpress 3.2 query_posts and pagination, permalinks issue
My question is not new but it just does not work with all found solutions in my case.
I am trying to display recent posts on single post using custom query_posts loop. The permalinks structure must ...
1
vote
1answer
518 views
How to limit search to first letter of title?
I was wondering if there was a way to make the search only look for the first letter in the posts title, basically let's say my search query is www.mysite.com/?s=q I'd like to get all posts that start ...
1
vote
3answers
699 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
1k 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
1answer
3k views
SQL query to select posts from multiple categories
I have built a query to select posts within a category. Works fine.
But when I choose to add a secondary filter to exclude a category, the query return the same result set, as if the secondary ...
1
vote
2answers
25 views
How to write: $wpdb->update having WHERE NOT value pair in the array
I need to update all meta keys in the postmeta table that have a value other than 0, to the value of 0.
I tried this.. no love (though I cannot figure out why....):
$status = $wpdb->query("UPDATE ...
1
vote
1answer
20 views
wpdb query problem to access previous 3 days posts
I am trying to get all published posts titles by author id 2 most recent by post date for the last days. Here is my query:
"SELECT post_title FROM $wpdb->posts WHERE post_status = 'publish' AND ...
1
vote
1answer
27 views
Admin Posts List (edit.php) by post IDs
I'm writing a plugin that creates posts in bulk. I provide a way for the user to set certain parameters of the created posts beforehand. But it would be useful to use the WordPress default "All Posts" ...
1
vote
2answers
49 views
How to List Parent Term Links for Custom Taxonomy With & Without Children?
I have a Custom Post Type of "projects", that is categorized by a Custom Taxonomy of "industry", which is heirarchical. Projects & sub-projects are assigned to the industries. For Example, the ...
1
vote
1answer
44 views
Wordpress Custom post query sorting does not work
I created a custom WP query to collect products that have 3 different taxonomy values in them and sorted them by price using the following:
$my_products = new WP_Query(
array(
...
1
vote
0answers
62 views
Changing status of Published posts which have less Content to “Draft”
function draftpost(){
global $wpdb;
$prefix = $wpdb->prefix;
$wpdb->query("UPDATE ".$prefix."posts SET post_status='draft' WHERE LENGTH( post_content ) <500");
}
...
1
vote
0answers
166 views
WordPress Query wp-terms SLOW
I've got a very large database in WordPress with lots of products in WooCommerce along with quite a bit of taxonomies. When querying the products on the front end it takes 1 minute or more.
Here is ...
1
vote
1answer
208 views
Trying to reorder posts by custom field
I'm running WooCommerce and am trying to get the default product display to be sorted by the sku field in ascending order. So far I've come up with this:
/* Order products by SKU */
function ...
1
vote
1answer
88 views
Query posts from different categories in multisite
In my planed multisite installation, I want the members to be able to post in one of two different categories.
Members in A can post in 1. Members from B can post in 2. All members can comment ...
1
vote
1answer
88 views
Is there a reason why Pages are not publicly_queryable?
I am building a segmented search (by post type) with the ability to filter to a specific post type and realized pages were not publicly queryable. What I know I can do is the following:
function ...
1
vote
0answers
53 views
register_taxonomy() take much queries
Sorry for my poor English, I'm russian.
I have a problem by adding a lot of taxonomies.
When I added about 80 taxonomies, I get the following results(without caching):
before: 44 queries 0.352 ...
1
vote
1answer
233 views
mysql query from wordpress page using custom table
I want to a mysql query that matches a page title. Not sure of a better way to accomplish this task, but I am stuck.
This is my basic test code.
<?php
$page_title = wp_title('');
echo ...
1
vote
1answer
56 views
Limits, not all post are showen when querying for posts by view count
I'm having some difficulty getting a loop that gives me post by most viewed.
I started by following this tutorial
...
1
vote
1answer
77 views
Query Page Content From Theme Options?
I'm trying to create a slider where you choose what pages are shown in the slider, using a theme options panel based on the https://github.com/vauvarin/options-framework-theme
That lists the pages in ...
1
vote
1answer
91 views
posts_per_page option limits the number of Gallery items
I have noticed that if I have a query where posts_per_page are set to 4, any (image) gallery that belongs to one of those posts will too have only 4 items (although when I create the gallery from Add ...
1
vote
0answers
58 views
Why orderbyb meta_value_num won't affect the generated SQL Query order?
I've exhausted myself with this and I couldn't figure out why when I do this
$myposts = new WP_Query( array('numberposts' => 5,
'offset' => '0',
'post_type' => 'noticias',
'orderby' => ...
1
vote
2answers
83 views
How to organise this data within WordPress
I have a dilemma in how the data in this scenario should be organised, as well as queried.
The main elements in the scenario are the following:
Competition
Team
Player
Each player plays for one ...
1
vote
0answers
58 views
Dynamically adjust single-posttype.php query, based on current taxonomies
I have a single-teamphoto.php template loading data from a Team Photo - Custom Post Type, showing team photos with team member names below, one photo at a time, with a navigation list of available ...
1
vote
0answers
70 views
category pagination got broken suddenly
i need some help here please!
The pagination just stopped working suddenly with the default post type and default wp query, with plugin "wp-paginate" or even with next/prev arrows!
It echo 404 error ...
1
vote
0answers
179 views
Exclude posts with taxonomy term from appearing on home page query
I am really confused about this one, I am usually pretty good at working out basic queries but I can't seem to work this one out.
Please see below my index.php query. Now it is not your basic query ...
1
vote
1answer
347 views
Sort posts based on multiple custom fields
I have a three custom fields
Meta Key → YOUR_PREFIX_newcar_body_type
Meta Key → YOUR_PREFIX_newcar_transmission_type
Meta Key → YOUR_PREFIX_newcar_variant
and I have to sort posts ...
1
vote
2answers
105 views
Query last updated posts (posts updated in the last 24 hours)
I'm having some difficulty to find an example of how to create a loop with posts that had been updated in the last 24 hours.
My idea is to have a page of posts or perhaps on the index.php a lists of ...
