A generic term referring to the process of retrieving information from a database.
0
votes
1answer
12 views
Query multiple custom post types in single loop
I'm aware there are several other posts that cover similar ground to what I'm about to ask.
I have three custom post types running, in addition to 'posts'. I want to run a loop that pulls all posts ...
0
votes
1answer
18 views
Get multiple posts with some custom fields efficient
Is there an efficient way to get some posts with (some of) their custom fields in one go?
I have a custom post with some custom fields and would like to create an overview page where I display all ...
1
vote
1answer
15 views
How Can I Query a Specific Page From a MultiPage paginated Post
Let's say I have a post that has been paginated by adding the
<!-- nextpage -->
code provided by wordpress for this purpose. How can I then query a specific page from inside of that post. ...
0
votes
3answers
39 views
Remove last comma from this query
I'm having trouble fixing this for working in ie8, i find out thats last comma is problem, but dont know how to fix it.
this is current code.
<?php $args = array( 'post_type' => 'katalog', ...
0
votes
1answer
24 views
Custom Wordpress SQL Query 4 posts per custom taxonomy
I'm currently developing a Wordpress website that has a large navigation that lists the 4 most recent posts within a hierarchical taxonomy. I dont have any experience with $wpdb, but it seems like ...
0
votes
0answers
11 views
organizing taxonomies in custom post type
I created a custom post type named "Gallery" which contains photos in several taxonomies e.g: Sport, Nature, Food, Drink. I want to organize all those taxonomies in my page "Gallery". So I can see ...
0
votes
3answers
121 views
+150
Taxonomy Drill-Down / Plugin Help - hierarchical queries within plugin?
I hope this question doesn't make me look too stupid!
I am using a plugin called 'Query Multiple Taxonomies' -- it's a fantastic plugin and is written extraordinarily well. ...
0
votes
1answer
42 views
WP-Snap too slow (caused by WP_Query?)
I have a website with 10.000 posts... WP Snap alphabetizes the posts and puts it out with WP_Query, but it is slow as hell, which is very frustrating. My question would be: what can I do about it?
...
1
vote
1answer
22 views
Searching With Apostrophe
I'm having trouble with my custom theme's search function. I have a number of posts with apostrophes in the title. For example, McDonald's.
However, when I try searching say McDonalds, the post won't ...
0
votes
1answer
36 views
How to display posts from specific category using get_option function?
I try to display posts from specific category only in a author page, using get_option function like in the code below but it does not work:
<?php query_posts('cat='.get_option('admin_cat')); ?>
...
0
votes
0answers
22 views
How to replace an ID with a get_option function in wordpress?
This is my code to retrieve the related posts from the same author in Wordpress:
<?php function get_related_author_posts() {
global $authordata, $post;
$authors_posts = get_posts( array( ...
0
votes
3answers
22 views
search through post-type attachments titles
I have a page where I show all the attachments of a page in a table which has id=10.
I have hundreds of attachments and I would like to implement an AJAX search form that uses the title of attachment ...
0
votes
0answers
29 views
Order custom fields by string length
I am trying to reorder a custom field from one of my Custom Post Types.
I'd like to get the custom field string which is called 'first name' and order all of the first names by their string length. ...
0
votes
0answers
33 views
Advanced Custom Fields Post Object
I am looking to create a custom proposal system with WP and ACF. I created 3 custom post types.
Proposal Objectives
Proposal Items
Proposals
I created some custom fields in ACF to include in ...
0
votes
3answers
55 views
2 wordpress loops showing 1 post from same post type - how to avoid showing the same post?
I got to two loops in my template files. Both querying the same thing essentially.
This loop in my header:
$testimonial_head = new WP_Query(array(
'posts_per_page' => 1,
'post_type' ...
0
votes
2answers
17 views
New Wordpress WP Query using posts from certain categories
I want to display the last say 6 pieces of work from my portfolio. So i have written this query
<?php $the_query = new WP_Query array( 'category_name' => 'portfolio', 'showposts=6' ); ?>
...
0
votes
0answers
14 views
Pagination now showing on custom query? [duplicate]
I have a problem with the pagination. Using the custom query i can display the posts that i want but i can't display the pagination after the loop.
How can i display the pagination and make it work?
0
votes
1answer
46 views
How to use Greek characters/letters in a query?
I have a problem with Greek characters in a query.
Here is the code
Using the Greek characters in the 'meta_value' => 'Ναι' the query can't work, because of the language.
How can i make it work?
1
vote
2answers
55 views
Is there a conditional tag for latest post or do i need a query?
I need to display an avatar in the post info position which i have written the code for but i only want to display it on the most recent post on the home page and not a specific post as this will ...
-1
votes
0answers
25 views
Execute mySQL query on publishing of post
I would like to post some data to a db when certain categories are selected in a WP post. I would like this to action when the post is made.
This is the query I want to run:
mysqli_query( $con, ...
1
vote
2answers
50 views
Optional Meta Query
I have places stored as posts in WP's posts table.
I am doing some geo-locating using Geo Data Store (http://wordpress.org/plugins/geo-data-store/). This is working great for me, as I can currently ...
0
votes
1answer
30 views
How to callback custom field text
I have a plugin where the user can click a button to feature a post.
I added a text field but i want the text field to call back whatever is posted in it
Here is how it looks now
...
0
votes
0answers
30 views
Combine Query and Select Database to create directory loop
I have a query loop on my page that I am using which displays all users on the page with certain custom fields filled out. It's working fine however, I need to also query these users for their level ...
1
vote
4answers
64 views
Add a class to posts in increments of 2
Is it possible to add specific classes to posts/pages in a query in increments of 2?
For example
Post 1
Post 2
Post 3 (add custom class)
Post 4 (add custom class)
Post 5
Post 6
Post 7 (add custom ...
0
votes
0answers
40 views
Marginal pagination on home.php
I'm trying too make a custom wp-theme and use a few loops in home.php. But now I can't finish home.php because of pagination. How cant I realize any type of pagination with saving that kind of ...
0
votes
1answer
111 views
How to add a prefix to existing custom fields over MYSQL query?
I've got the problem that after a plugin update I can make the custom fields on our directory site searchable, but only custom fields which get the prefix booking_ to them.
Now there are some pages ...
0
votes
2answers
21 views
Find all posts via SQL beginning with A of type B
I have problem with post and taxonomy query. What i need is to get all post's from custom post type which starts with A and have defined term. Here is my sql:
SELECT * FROM $wpdb->posts, ...
0
votes
1answer
18 views
How do I add tags/taxonomy to images + a query field on page to query 'albums' (images with same tag/taxonomy)
I've got lots and lots of photos on my site and I want to seperate them into albums. Every album is a client album (photoshoot).
Though.. I want all my clients to query their album on my site. ...
0
votes
1answer
16 views
Show links to child pages on both parent AND child pages
I have a client who wants the following;
They have a series of pages, each of which have children. On the parent pages they want to show links to all the children. For this I am currently using this ...
1
vote
1answer
33 views
WordPress Loop: List All Posts by a Category & Subcategory
I want to display all post under a category and all subcategories under the parent categories. But couldn't find proper suggestion over forum or failed to understand the solution. It's possible to ...
0
votes
1answer
20 views
Checking for existing title in custom db query not working
I want to check if the title exists before the wp_insert_post() is triggered.
However, the condition seems not to work as expected:
if( $wpdb->get_row("SELECT * FROM wp_posts WHERE post_title = ...
-1
votes
1answer
19 views
Multiple loop with pagination in same page
In my home page i have two <section> in which i perform two different loops on different post categories. Here the code:
<section>
<ul class="loop-article">
...
0
votes
1answer
32 views
List of buyers for each product
I would like to know if it's possible to get the complete name of each buyers for a specific product or the orders list of a specific product ?
2
votes
1answer
71 views
How to implement time filter to show random post 1 month for one category and 3 months for other categories
I started to work on one website after another developer and there is problem with his "popular widget" which is basically showing 3 random posts from category. There is some Switch statement which is ...
0
votes
0answers
22 views
Post from one WordPress site to another
I have two sites running on WordPress. I have a form on one site that generates a custom post type, and I would like this custom post type to be posted to another WordPress site. How can I do this? Is ...
0
votes
1answer
30 views
Best practice to limit results in get_row()?
This is my query to check if a title exists (it's in a loop, therefore [$i]).
$wpdb->get_row("SELECT * FROM wp_posts WHERE post_title = '" . $titles_arr[$i] . "'", 'ARRAY_A');
Anyway, I would ...
0
votes
1answer
33 views
Post content stays the same but permalink changes ?
This is really weird. I made a posttype ' mediagallery ' via the plugin Types fields.
I simply want to load the post content and switch the posts with a next & prev button in de sidebar.
The post ...
1
vote
2answers
39 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 ...
0
votes
0answers
39 views
List number of posts with a specific meta_key for each meta_value
I would like to list my posts by a specific custom field. At the same time, for each custom field, I would like to count the number of posts with a specific custom field value.
I have a custom field ...
0
votes
0answers
35 views
Complex WP_Query Using Post Date And Post Meta
I am using Wordpress as a CMS on a website which has standard posts, a custom advert post type and a custom event post type. The event post type has some custom meta which stores the event start date.
...
0
votes
1answer
20 views
Adding an orderby filter, casting postmeta with multiple keys
I am using this filter to sort my query by a date field stored as text (legacy data)
add_filter( 'posts_orderby', 'my_posts_orderby_date', 10, 2 );
function my_posts_orderby_date( $orderby, $query ) ...
0
votes
2answers
41 views
Set conditional on template based on referring page slug
I have a portion of a page template that is conditional upon the following elseif
<?php elseif( isset( $wp_query->query_vars['details'] ) && $wp_query->query_vars['details'] == ...
0
votes
0answers
30 views
Displaying hierarchical taxonomy terms on taxonomy template
Sorry if this is a little long but it is somewhat complex. I thought I was going down the right path. Here it is. I have created a custom post type and a custom taxonomy for it named location. In this ...
0
votes
1answer
28 views
How can I get the name of term post meta value which equals term id
I have a custom taxonomy (location) that is being populated automatically by an advanced custom field on user save. The issue is that it saves the term_id in the postmeta meta_value field. When I echo ...
0
votes
1answer
44 views
Exclude all sticky posts front page twenty twelve
I am attempting to exclude all sticky posts from my front page in twenty twelve theme. I have attempted the following. I am making all changes to the child theme.
To remove the following code from ...
1
vote
1answer
43 views
Perform query with meta_value date
I am trying to perform a query on a custom-type post using the value of a custom field.
This field contains a string date: dd.mm.yyyy.
The post type name is 'event'
The custom field name is ...
0
votes
0answers
20 views
Run a query when in last category
Can anyone help? ive searched google but with no luck.
currently Accounts has sub categories but no posts
/accounts/ = /billing1/ + /finance/
Billing and finance have posts but don't want ...
0
votes
0answers
29 views
Pre Get Posts fails with more than 1 Post Type
Inside Functions.php
function custom_filings_archive( $query )
{
if(is_post_type_archive( 'filings' ))
$query->set('post_type',array('the-reports','press-release'));
return $query;
}
...
1
vote
2answers
44 views
Disable the MySQL query in the main query
I would like to disable the MySQL portion of the main query, i.e. I want every step to be followed on this page EXCEPT step 4.3: http://codex.wordpress.org/Query_Overview
What's the easiest way to go ...
0
votes
1answer
56 views
How to display only one category in a custom post type?
I have a custom post type called 'portcat' and I want to display the results of only one portcat category ('games' - which has an ID of '3') on my page. The below code displays all of the categories ...
