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

learn more… | top users | synonyms

0
votes
0answers
4 views

Query if audio attachment AND/OR custom field

I've been trying several things but to no avail... Searched, maybe not good enough though! I have posts that either have an uploaded audio file AND/OR has a Soundcloud link (which is a custom field). ...
0
votes
0answers
13 views

Add generic page to WP_Query

I have a query that gets all my custom post types of Service. I need to add a generic page (Classes) to the query so that I can use the orderby argument. I know the ID of the page I need to add. How ...
0
votes
1answer
23 views

Inner join overrides Advanced Custom Fields plugin's get_field

I have this search that I made with inner join and where clause. I no longer get get_field() values, they all return false. How can I get ACF to work again? It must be something silly that I don't ...
0
votes
1answer
19 views

How to add div blocks after certain set of post

Ok I broke my post down into different style settings. Like shown below. The first post is a large block. the next four post are small and aligned next to the larger post. I used the loop below to ...
0
votes
0answers
8 views

MySQL query in Functions.php using inner join to override/add to search

I'm setting up a radial geo-location search. I have users select a zipcode and a radius to search within. I want to use the regular search site.com?/s=abcd&zipcode=90210&radius=10 I look up ...
-1
votes
0answers
6 views

Query custom post type by taxonomy without running the whole custom post type

This query that I have show all the posts that I have in my books custom post type: <?php query_posts('post_type=books&showposts=-1&order=DESC');?> <?php while (have_posts()) : ...
0
votes
1answer
23 views

Hide text if query has no posts

I'm using a custom query to display events CPT inside another CPT. The given query has a section title, which I don't know how to hide when there are no events. I've tryed to include the section ...
0
votes
2answers
32 views

Problem in exploding the_content to array

I've written a code in a WP_Query to converting a string (the_content) to an array (choices). But it seems wrong! In fact, the choices array is empty after each loop. However str string is notnull. ...
0
votes
1answer
17 views

Create custom query for search?

I have create search box using ajax.If i enter any value in search input box that this value search in post title or post meta data and get all data of this value in custom post type.also query check ...
0
votes
1answer
16 views

Empty tax_query array returns an empty array

I would like to return all posts when the tax_query['terms'] is empty. $args = array( 'post_type' => 'product', 'posts_per_page' => 15, 'paged' => $paged, ...
0
votes
1answer
35 views

Get the post permalink within the loop but without additional DB query

I am looking to create a custom 'directory' page which will link to several thousands of posts. Because of the large number I am trying to limit the number of DB queries. I notice that to link to each ...
0
votes
1answer
17 views

Advanced Custom Fields Query with Different Values of the Same Key

I have a custom post type set up with Advanced Custom Fields. I would like to display and order my posts in groups. The groups are states of the United States, so I have 50 groups. Should I perform ...
0
votes
2answers
20 views

Where and when does WordPress invoke routes

One of my URLs for which I'm wanting to create a Category Archive is coming up with a 404 despite having matching routes and, supposedly, matching templates. I'm going through the core WordPress code ...
0
votes
0answers
8 views

No results for taxonomy archive page

So, I'm making a taxonomy template page for a plugin, but I'm not getting any results from my query. I'm loading the template with this. function projects_categories( $taxonomy_template ) { if( ...
-1
votes
0answers
9 views

Genesis and Woocommerce Products Per Page

I’ve been searching for an answer for this for a while and am stumped. Any ideas are greatly appreciated. I’m building a custom child theme on the Genesis framework, and am stuck on the WooCommerce ...
0
votes
1answer
17 views

meta_value timestamp older than now

In my wp_posts table I want to select the rows where post_type == event. I also want to a connection with wp_postmeta from the specific row. In my wp_postmeta table I want to do a where like this: ...
0
votes
0answers
12 views

WP Query for newest post of each taxonomie of a custom post type

I'm trying and googleing since 2 days, but cant figure out how I can display my 8 needed posts. Details about my structure: I'v created an custom post type "projects" where all the posts about ...
0
votes
1answer
55 views

How to show posts rank based on custom field value

I have total 100 posts, 10 posts in each page on homepage with paginatin. Here is my code $args = [ 'posts_per_page' => 100, 'fields' => 'ids', // Add additional args here ]; ...
0
votes
0answers
10 views

Get adjacent post data, ordering by custom field values (by Wp-query?)

I want to build a custom version of the adjacent-function of wordpress post. I have two custom field values for each post, my layout is the following: metafield1 value 1 & metafield2 value 1 | ...
1
vote
3answers
69 views

Limit number of pages in pagination

I have more then 500 posts and I want to limit only 100 posts with pagination. So, 10 pages with 10 posts in each. Here is my code. $paged = get_query_var( 'paged' ) ? get_query_var( 'paged' ) : 1; ...
0
votes
0answers
16 views

Add a banner image after first post, across the WordPress website [duplicate]

I am looking for a way to add a banner image after first post across the website. If it was about adding a banner on one page only, homepage or category page, then I could have done this in WordPress ...
0
votes
0answers
10 views

How can I take input from a form, run it through a custom query, and display the results?

I'm having a good bit of trouble here. I'm working on a plugin that should be able to, among other things, allow the use of a shortcode to search through custom post types and their custom fields. I ...
0
votes
1answer
56 views

Ascending & descending posts on same page with IF statement

I need to be able to display a list of events on 1 page. The top list would be for upcoming events and to be sorted with earliest event first and the second list would be for expired/past events and ...
0
votes
0answers
15 views

Problems with database query where two metavalue-key pairs meet condition

I've been trying to put together a database query where the different meta_values of two different meta_keys match the query. One example would be: delivery_date is '2015/06/11' AND supplier is ...
1
vote
2answers
34 views

WP Query. Is there a maximum size?

I develop a plugin that searches for a duplicates of WooCommerce products in a very specific way. It works great in our test environment, but on the client's original setup it does not execute. It ...
0
votes
0answers
21 views

Add custom field to string URL query

I recently took over a wordpress site from a former employee and I have 0 experience with this CMS aside from creating child themes. That being said, I'm trying to allow my search page to list out all ...
0
votes
1answer
26 views

Is it possible to query the result of a query?

I'm not sure if the is even possible, and couldn't find an answer, so I figured I'd ask on here. Basically I want to know if it is possible to query a query result? What I want to do is query for ...
1
vote
0answers
40 views

How to query all posts of a specific category, and any other category combination

Basically, I'm looking to query all post of category 'news', and any combination of other categories to display as Related News on single content type pages. So, if someone writes a post, and ...
0
votes
1answer
24 views

Mysql query not working on Wordpress 4.2.2

My friend made a xml generator plugin what is owrking fine with WP 3.5, but i need to update for 4.2.2 (cause the security) and the plugins now said 'No database selected', but the informations / ...
-1
votes
0answers
15 views

Customization in Wordpress Plugin - Search result page

I am using a WordPress plugin for travel search by Travel Grove. This is the url : http://www.designgridstudios.com/demo3/ . After filling the search form it points to Merchant site and compare the ...
0
votes
0answers
34 views

Loading posts from another wordpress database on the same server

I've searched quite a while and found several solution but apparently I'm doing a lot of stuff wrong. I'm having 4 different Wordpress sites and need to load the latest 2 posts of each site. For ...
0
votes
0answers
8 views

Mysql join 2 columns into 1

Hello i could really use a hand here.. the thing is i want to make 2 tables for a project - 1: Shifts: - which has: id, usr_id, date, start_time, end_time, and pending - 2: shifts_extra: - which ...
0
votes
0answers
36 views

Query post by meta key of another table

Im using event calendar plugin where I can set event date for posts and it shows in calendar widget. Everything is working as inteded but I would also like to query post by event date. I know how to ...
0
votes
1answer
20 views

Need help with custom rewrite rule

I have a CPT called presskit, and I need to add a custom query var named welcome_box. I have this code right now: function my_new_url_querystring(){ add_rewrite_tag( '%welcome_box%','([^&]+)' ...
0
votes
0answers
12 views

Search within multiple authors posts with Relevanssi

Is it possible to search within multiple authors posts? When I try to create a array and pass it to the query it gives me: explode() expects parameter 2 to be string, array given in ...
0
votes
0answers
19 views

Creating a top and display the top position inside post

I've create a top of the best football players in the world with a custom post type and i added to each player a custom field for goals/salary/country etc. Now i need to know if you guys have any ...
2
votes
1answer
101 views

Why does get_the_time('F j') return November 30 for all posts?

Okay, so I'm making the blog page for my WordPress site. My front page is displayed as static, so my blog posts are on another page called "Journal." I want to display the posts in an archive-like ...
0
votes
1answer
36 views

How do I get the index for a custom post?

This is kind of a different request, but my client wants the index of a custom post type. Basically for a regular post, they can select 1 custom post from a list in a custom field to "attach" to the ...
0
votes
1answer
16 views

Sort / Filter Queries

I'm working on a website, that showcases products, and now I'm working on the query part. Basically I want to have one page, that displays a list of products as a normal query, and then on top of the ...
0
votes
1answer
61 views

Updating with $qpdb->query() always returns 0 rows affected

I'm experiencing an odd situation while running an UPDATE with $wpdb->query(). Given the users table, with columns user_id (Primary Key) and status, and the user 3 existing and with status 0, I ...
0
votes
1answer
29 views

Getting custom post types to properly display alphabetically

I'm trying to get the sub loop of custom post types to display in alphabetical order, but having no luck. I've tried applying ksort and asort to the $posts array, but it just reorders the ID display ...
0
votes
1answer
35 views

Delete data from custom table in wordpress

i am trying to delete record from my custom table global $wpdb; $retrieve_data = $wpdb->get_results( "SELECT * FROM wp_paypal" ); echo '<table border=1 class="table table-striped"> ...
0
votes
1answer
35 views

Select query for a login

I'm trying to make a login form, but select query isn't working. Is there another syntax in WordPress and in which way is password hashed? My code is: if ( isset( $_POST['submit'] ) ) { if ( ...
0
votes
3answers
86 views

Using WP_Query in “parse_query” or “pre_get_post” in Posts2Posts

UPDATE: The hook is working with "classic" Wordpress filter (like post__in), so it's probably a Posts2Posts issue. I'm still looking for suggestions if someone has any idea. ORIGINAL POST I'm ...
1
vote
1answer
19 views

How can I apply a meta query for a single custom post type in the main query?

I have custom post type called event, which has custom fields for start_date and end_date. For the event archive, I'm filtering out "expired" events using the following meta query added to the main ...
2
votes
2answers
192 views

Conditional to modify query results

I'll admit, I'm not a PHP expert, nor am I familiar with all of the WordPress functions and hooks. I've been stuck on an issue, searching for help without much success, and I was hoping that someone ...
0
votes
0answers
23 views

WP Query - Group by relation (custom post type)

I have a custom post type Office. An office has an address, email, ... . An office also has a relation with a custom post type Region. So an Office must have a relation with a relation with one ...
0
votes
1answer
24 views

Create query for both custom post type and category

I have a custom post type called articles and have category = news I want to make a query from the two parts to get content from (cpt=articles, category=news) in the same query? How can I achieve ...
0
votes
1answer
30 views

Counter is skipping post when I still want it visible [closed]

I am showing the 5 latest posts on my homepage. I am using a count so that on the 3rd post it shows a div which will be completely seperate to the blog posts. However rather than the 3rd post ...
-1
votes
1answer
43 views

Showing specific post in order of array wp_query

I have displayed some specific post ID's in a custom template with wp_query. I am struggling to figure out how to make these in order. I want to show 1682 first and 1540 last. They do not show this ...