A generic term referring to the process of retrieving information from a database.
4
votes
2answers
267 views
How to display Section for certain time
i am building a News site. I want to display 1 featured post from "prime" category for only few hours. after it should be expired or disappeared from the section.
please have a look here u can see ...
0
votes
1answer
111 views
Conditional category query breaking?
In my loop.php (see below) I basically have a condition where if the page is not paginated (i.e. if the URL does not look something like this: example.com/page/2) then display 2 posts with a category ...
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 ...
3
votes
2answers
512 views
Sort custom post type list table by display name of a user id stored as post meta value
I have a custom post type named domicile. Each post (domicile) has an owner (not the author). Owners are users with a custom role. I store the user id as a post meta value (dmb_owner) for the domicile ...
0
votes
1answer
151 views
Pull post meta with post_query?
I'm building a custom index loop that just uses query_posts at the moment.
The issue is that inside The Loop, I have to then query for the post meta data (with get_post_meta), which I believe has ...
0
votes
1answer
168 views
show posts only on homepage but using custom post type and taxonomy for query posts via url
I would like to do the following:
I have a index.php file in which I query all posts from the existing post_types. Like the code below.
<?php if (is_home()); { ?>
<?php
global ...
0
votes
1answer
234 views
Show only, when taxonomy has posts?
I'd like to query posts by taxonomy like this:
<?php
global $post;
$terms = get_the_terms( $post->ID , 'movies', 'string');
$do_not_duplicate[] = $post->ID;
if(!empty($terms)){
foreach ...
0
votes
1answer
657 views
$wpdb->get_var not returning a result
I launched mysql and confirmed this query returns a result:
mysql> SELECT * FROM wp_posts WHERE post_parent = 68 AND post_type = 'attachment' AND post_name = 'side-logo-auto2' LIMIT 1;
1 row in ...
5
votes
5answers
698 views
How can I make wp-pagenavi work on a custom query built upon a form submission?
I've also posted this on the wordpress support forums, for scribu's wp-pagenavi plugin:
http://wordpress.org/support/topic/plugin-wp-pagenavi-custom-query-form-submit-part-2?replies=1
My situation:
...
0
votes
1answer
835 views
Query Posts By Post Publish Date, but sort by Custom Meta Key
I'm trying to show the most popular (recent) posts on my blog. I have made a special formula for this. I am querying for these posts like so:
$args = array(
'post_type' => 'post',
...
0
votes
2answers
1k views
Custom $wpdb Query for Custom Post Type by Category
I am using the following code to output a list of items in my 'documents' Custom Post type by Year and Month.
<ul>
<?php
$post_type = 'documents';
global $wpdb;
/**/
$years = ...
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 ...
0
votes
2answers
207 views
Include different loop templates in search query
I have differnet Custom Post Types in my blog. I also have custom templates for each of them like loop-{$cpt-name}.php
I would like to include different cpt templates dynamically in search results ...
0
votes
2answers
133 views
Parsing External Table Arguments
I have a client project that has posts assigned to their country of origin.
The client wants to be able to search the posts by continent and or region.
I have a separate table that assigns each ...
0
votes
1answer
184 views
How can I query all post with currrent taxonomy term?
I created the taxonomy 'machine types', and added several terms to it, like 'cranes' for example.
The url to that term now looks like this: domain.com/machine-types/cranes
How can I make this url ...
0
votes
1answer
242 views
Get all pages to display at once
I'm doing a theme that is supposed to be ease to create, but I have now reached a standstill and need to get past this.
Is there a way to display/show all pages at once? Or can I create a custom ...
0
votes
1answer
41 views
Custom Query for Taxonomy
What is the correct wpdb custom query for this:
taxonomy=pa_main-genre&post_type=product&orderby=name&order=asc
Basically i am trying to do is,list all the terms for pa_main-genre. ...
1
vote
1answer
349 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
3answers
2k views
Custom Post Types, Page Templates and Pagination. Why do I get a 404 Error?
I have spent hours today on a maddening issue I was having with displaying a custom post type. Everything displayed beautifully, except the pagination simply would not work properly.
I have a ...
0
votes
2answers
198 views
Disable (or limit) queries when certain content (or data) is not needed (or showed)
Currently I am making a custom design for a site. The problem I'm seeing in Wordpress is about almost all data pulled out from the database.
While in certain pages - like front-page.php - it only ...
0
votes
1answer
197 views
How to retrieve attachments from child pages of a specific Page?
How would I retrieve attachments from all subpages of a specific Page ID?
Example:
SPECIFIC PAGE
Child (with attachments)
Child (with attachments)
Child (with attachments)
I'm currently ...
0
votes
1answer
901 views
How can I create a meta_query with an array as meta_field?
Here are the args for my query :
$args = array(
'post_type' => 'news',
'meta_query' => array(
array(
'key' => 'topics',
'value' => 'sports',
...
0
votes
2answers
188 views
List Wordpress Post and Related Attachments outside of a post page
I've been having difficulties with some new functionality I've been trying to create. Basically I have a custom page setup that displays a list of all posts with a specific tag. What it needs to do is ...
0
votes
1answer
110 views
Passing values by form to create a query
I have this structure:
taxonomy
- term1
-- child term1
-- child term2
-term2
-- child term1
-- child term2
I have two select boxes. First one shows the parent terms (term1 ...
0
votes
2answers
1k views
All in One Calendar Plugin Custom Post Type Query
Hi I'm trying to write a query which will pull the events out from the All in One Calendar Plugin. This is what I have so far:
<?php query_posts('post_type=ai1ec_event');?>
<?php while ( ...
0
votes
1answer
2k views
Display Content if Meta Checkbox is checked?
Basically i have a custom post with a custom metabox, with a checkbox inside it.
If you check the box i want something (styled box) to appear within the post loop.
If not checked the box doesn't ...
0
votes
1answer
241 views
How to query / DB requests?
what is the correct way to query the a Wordpress database, meaning to pull row and column info, and then place it into a corresponding table in the Wordpress admin?
I'm wanting to do a query similar ...
0
votes
1answer
433 views
How to Loop within a Loop (Display Children and then Grandchildren)
I am trying to develop a query for WordPress that will allow me to display a list of child pages with titles only, and then under each child page title, a list of grandchilden (children of the child) ...
0
votes
1answer
93 views
Recent activity query WordPress
Does anyone know how I can get a list of posts based on their recent activity? Activity such as a new comment, an edit, a new post, et cetera.
Some Q&A wordpress themes seem to be using this but ...
0
votes
1answer
44 views
Make (custom) post type accessible only by custom query
I am trying to make a web application based on wordpress.
This application needs some text data to process and then display to users. For that I use a custom post type. So far so good.
Problem is, I ...
2
votes
1answer
184 views
How can I get all posts data from within a paginated search result?
Let's say I'm doing a search on my site, and get 50 posts as a result. The pagination is set to 10 posts per page, so I have 5 pages of results.
When I'm on the first page of results, if I inspect ...
2
votes
3answers
476 views
Wordpress query by category, sorted by custom field
I have three custom fields set for each of the posts in the events category — year, month, and day. I am already querying for the events category, and now I'd like to sort the posts by the custom ...
0
votes
1answer
34 views
Modify Global Posts Plugin
I am trying to modify a query from wpmudev called global blog posts . I need it to not show any of the default blog posts, the first post on each blog.
$query = "SELECT * FROM " . ...
1
vote
2answers
108 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 ...
0
votes
2answers
73 views
Creating a widget that displays the content of a page
I have a page that displays information from a query (I placed the output of the query in a custom page template and have the information display that way). How can I put this information into a ...
2
votes
1answer
1k views
WordPress Paginate $wpdb->get_results
Due to a complex multisite config, I have a query which combines the posts from two blogs and I would like to paginate the results. I am grateful for any help. I have posted my query.
...
0
votes
1answer
54 views
Sorting date results from a query
I have a site I run which shows the weddings and anniversaries of some friends.
I have this running to show the users (and their anniversaries) according to what month it is:
$args = array(
...
1
vote
2answers
446 views
Search queries don't seem to work?
I have a problem with search queries. Anytime you put additional queries, like:
mywebsite.com/?s=wordpress&post_type=page
mywebsite.com/?s=wordpress&post_type=page,post
...
0
votes
1answer
62 views
How can I add more code to this?
<?php $my_query = new WP_Query( "cat=11&posts_per_page=1" );
if ( $my_query->have_posts() ) {
while ( $my_query->have_posts() ) {
$my_query->the_post();
...
0
votes
1answer
178 views
How to get the term description in a taxonomy term archive query?
I'm creating a template for a custom taxonomy for my theme.
At the beginning of the page, before the loop that lists all the posts associated to a term of that taxonomy, I want to output the ...
3
votes
4answers
741 views
the_date() not working
I am using wordpress 3.2 and I did a query post like this:
<?php query_posts("posts_per_page=1post=type&page=post_parent=10");?>
Then I try to echo out the date of this post I queried ...
2
votes
3answers
1k views
get attachments for all posts of particular post type
I'm making a widget that shows a set of images from recent custom posts. I want to run the following query:
SELECT p.*
FROM wp_posts p
WHERE post_type='attachment'
AND post_mime_type LIKE 'image%'
...
0
votes
1answer
209 views
SQL: Search query to get attachments only of those parents which are published
i'm having some problem creating nice 1 query to be able to get search results which includes NOT only post_type POST but also attachments. BUT if search query return attachment, i want that it won't ...
1
vote
2answers
155 views
How do I find if a page has a template?
So I'm doing a query like this:
$the_query = new WP_Query( array( 'meta_key' => 'homepage', 'meta_value' => 'yes',
'post_type' => 'page', 'orderby' => 'modified', 'posts_per_page' ...
0
votes
1answer
349 views
Custom SELECT Query With Multiple Meta Values (Ordering Problem)
I have two custom meta values that I am using for an events list and have almost got everything working perfectly except for the ordering. I have two dates (event_date and event_enddate). One of these ...
0
votes
1answer
84 views
Get post ids sorted by meta_key
I have defined a post_view_count meta_key to store the number of post views.
I would like to get an array of post ids sorted by post_view_count value to use in the
functions.php file.
Thanks.
2
votes
1answer
220 views
How can I query all users who registered today?
I'm trying to use meta_query to return all users that have registered today :
$args = array(
'meta_query' => array(
array(
'key' => 'user_registered',
...
0
votes
1answer
69 views
Retrieve or Query Pages by ID
I have a problem with my code, I want to display 3 specific pages on my homepage but my code is not working.. here's the code..
<?php $args = array(
'post_type' => ...
0
votes
1answer
241 views
Excluding posts by meta, and also keeping posts without the meta
edit: Think I managed to figure it out, check the answer right under here, or click the following link:
http://wordpress.stackexchange.com/a/51175/15809
I've been trying to find a way to exclude ...
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 ...
