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

learn more… | top users | synonyms

0
votes
1answer
400 views

SQL query equivalent to WP User Query

I have the following WP user query code: //Get all users sorted by whatever $sorted_users = new WP_User_Query(array( 'orderby' => 'meta_value', 'meta_key' => 'satisfaction_rating', ...
0
votes
1answer
152 views

WP_User_Query orderby meta_val_num

I know that normal WP_Query's can have an "orderby" parameter of "meta_value_num", but when I try to user "orderby" => "meta_value_num" on a WP_User_Query, it doesn't seem to work. Anyway I can ...
1
vote
1answer
81 views

Query posts using meta_key

I am trying to rank results based on the value of a meta_key. This is my form <form action="<?php echo home_url('/');?>" method="get" data-javo-patch-form-for-result> <input ...
0
votes
1answer
177 views

show posts found in multiple categories via category_name query string?

I am attempting to allow visitors to filter posts in an archive to show posts that are found in two categories. The code is building the URL as follows: domain/?category_name=slug1+slug2 Previously, ...
0
votes
0answers
221 views

Ajax Form data is not posted back to the get_results()

I am trying to run a wordpress wpdb->get_results select query and I want to get the search criteria from a textbox. I want to do it form and with ajax without refreshing the page. No matter what I do ...
0
votes
1answer
107 views

Ajax Query returns zero

I am doing simple wordpress select query and want to do this with ajax jquery and do not want the page to refresh when I press search button and writing text in search textbox. As soon as I press ...
0
votes
1answer
2k views

Get all user meta by meta key instead of ID

I'm trying to compare user meta values to find highest and lowest values. I have a user meta value set up called "hourly_rate". I want to get the hourly rate for all users and then run PHP's min() and ...
2
votes
2answers
113 views

get_the_foo() in the loop - does it perform another query?

I'm unclear on the get_the_foo() style of functions, for example get_the_permalink(). My main question is: when this is performed in The Loop, is another SQL query executed (besides the original ...
0
votes
2answers
302 views

$wpdb->query can't insert data

I Write Code to Save data in the Wordpress database table (table name is wp_fafa) But Can't Save data in $qry = $wpdb->query( "INSERT INTO `wp_fafa` ...
0
votes
0answers
145 views

Using $wpdb (WPDB class) 'replace' with multiple WHERE criteria problem

I have two fields that are used to identify a particular row (acting as a composite key). If it does not exist, I wish to insert a new row. The REPLACE function ...
1
vote
2answers
135 views

Query posts if meta key starts with

I need to find posts with a meta key that starts with the current year + the current month (i.e. 201502), but the actual value could also contain any day within that month (i.e. 20150214). The ...
0
votes
0answers
129 views

Pagination not working in custom post page

I have this theme that I created which is a mix of code copied and mixed from different themes, and I have a custom post page in the theme where pagination isn't working for some reason. <div ...
0
votes
1answer
200 views

You have an error in your SQL syntax - Help with query

I have a programmer that developed a custom plug in for a client's website and after moving the site to client's server, some parts are not working. Looking at the error log, there is an issue with ...
0
votes
1answer
396 views

3 Posts in Loop, Show Stickies First

Okay I am starting to wonder if it is even possible to do this! As I've found very little info on the matter online. This is a fresh WP install that I've been experimenting on so that I can work in a ...
0
votes
0answers
49 views

wp_query - Modify $query to include duplicate content

I'm setting some featured content through the customizer (it's saved in theme_mod); Using the pre_get_posts hook, I'm retireving the feature pages in this way: ...
3
votes
2answers
934 views

Return only Count from a wp_query request?

Is it possible with the standard build-in tools in Wordpress to get wp_query to only return the count of an query? Right now, I’ve a query which has several meta_queries but what the only thing I’m ...
0
votes
1answer
123 views

Query Set Order By Author

I am attempting to orderby the author_name when you click on the Author arrow on a list of tickets. When you click the arrow, the names are ordering by something I cannot identify. I want them to ...
0
votes
1answer
1k views

WooCommerce search products between price range using WP_Query

I am currently building my own custom advanced search functionality for a WordPress website with Woocommerce. You should be able to search using: Category Min/Max price My current progress is ...
0
votes
1answer
233 views

WP_Query custom order and pagination

I am seeing some strange behaviour when combining a custom order with pagination when using WP_Query. The arguments for my query are as follows: $args = array( 'post_type' => 'news', ...
0
votes
2answers
969 views

Make a WP Query search match exactly the search term

I'm using WP Query and the results coming back when using the search term aren't working as I wish. For example searching for 'art' returns also results for words containing 'art' such as 'part'. How ...
-1
votes
1answer
65 views

query grandchildren taxonomy terms

I have a function that queries the children of each taxonomy terms, I'd also like to query the children of these children terms too, my markup is as follows: <?php $terms = ...
0
votes
0answers
15 views

how to create advanced search [duplicate]

I'm really stuck in this and i cant find any tutorial or article about this topic. How about if we have this pattern for search: [country] AND [category1 OR category2] AND [city1 OR city2] AND ...
1
vote
1answer
121 views

How to add a post or page tag to the list of classes appearing in the body tag's class attribute?

Good day, Perhaps you are willing to help out a php-beginner. I'm trying to add a post or page tag to the list of classes appearing in the body tag's class attribute. These classes are printed onto ...
2
votes
1answer
48 views

How to do a query on custom taxonomies that is uncategorised?

I have a custom taxonomy and I wish to do a query for all custom posts who has no value assigned for that taxonomy (i.e. uncategorised). This is what I have so far: $uncatQuery = new WP_Query( ...
2
votes
2answers
151 views

$args numberposts variable

$args = array( 'numberposts' => '10', 'post_type' => 'newposttype'); $recent_posts = wp_get_recent_posts( $args ); I know it's not a simple thing to ask but how could I set the numberposts ...
0
votes
1answer
87 views

Using WP_Query to re-query and sort results using a date?

I'm writing a function to find the users next upcoming event (stored as CPT), chronologically. If I use a normal query and do something like 'post_type' => 'ticket', // another CPT set up to act ...
1
vote
1answer
122 views

How to get to a specific position in wp_query?

Background: I'm trying to display images in a slideshow, and I want to select those pictures randomly from the website's media. The image has a custom field in order to be selected for being the ...
0
votes
0answers
48 views

Optimising specific Query with ACF meta objects

Is there any way I can improve the following query without touching the server, as it's taking around 5-6 seconds to execute, the SQL is outputing as: SELECT wp_posts.* FROM wp_posts INNER JOIN ...
0
votes
1answer
329 views

i'm trying to get all my media query attachments via ajax in wordpress

i'm trying to load all my media files via ajax: $.ajax({ url: '/wp-admin/admin-ajax.php', type: 'post', data: { 'action': 'query-attachments', 'post_id': 0, ...
0
votes
1answer
70 views

Display the latest post from some selected authors

I'm building a slider that will display the latest post of a few selected authors. So far, I've written this: <?php $args = array( 'post_type' => 'post', 'posts_per_page' ...
0
votes
0answers
37 views

How do I get a nested query to only display content that the main query outputed

I have a CPT 'artists' and a CPT 'events' I want the 'artists' to query first based off the posts tag and then I want the 'events' to query events based off what 'artists' was queried. Heres what I ...
0
votes
2answers
478 views

get_posts showing only 5 posts. (nopaging and posts_per_page -1 not working)

I have this piece of code which works but it's showing only 5 posts (with custom taxonomy) where should be 7. If I hit the tag url, it shows the 7 registries, so the problem it's in this code and its ...
1
vote
1answer
89 views

How to detect if query is runned from widget?

I want to know if exists function that detect if some database query run from widget, for example from recent_posts widget or search_widget.
1
vote
3answers
458 views

How to display all posts with today's same month and day only?

I'm trying to figure out how to do this. I have many posts. I want it so that when someone pulls up the site, the front page shows all the posts that were done on the same month and day -- but ...
0
votes
1answer
270 views

Problem on wpdb queries, wp_insert_post, wp_insert_user etc. The query runs twice

Anyone encountered this issue? I have created a custom php script which adds a new post by using wp_insert_post() but everytime I run the code it creates a 2 new post where in it should be only be ...
0
votes
1answer
2k views

Retrieve and display data from custom db table in admin area?

So, i'm having a bit of an issue with a plugin i'm developing, I wonder if anyone can shed any light on the situation, as many, MANY searches have come back with zero help. :-/ Basically, my plugin ...
0
votes
1answer
31 views

How to query custom post type one after another

I am trying to query my custom post types. I can display both of them with this code: 'post_type'=> array('map','item') But I don't want them to mix. I want "map" to display before "item". ...
0
votes
1answer
325 views

Order posts by tags count?

I am trying to order posts by tag count. I want to order posts with no tags first and posts with highest count last. I tried and got posts with no tags only. $tags = get_tags(); $tag_ids = ...
1
vote
1answer
356 views

How to add posts to wp_query result?

I have 2 user groups: authors and clients Authors can publish posts and specify in metabox for wich client these post is ment for. Client can publish posts and view, edit posts, created by Authors ...
0
votes
1answer
73 views

How to get several fields from wp_query?

I'm going to get several fields from wp_query result. I know about wp_list_pluck() function, but it accepts only one field paramether. How to get several ones if I'd like to take several parameters ...
0
votes
1answer
59 views

Loads posts of different year via AJAX call

I need some advice with this one. I want to load posts of certain years depending what year the user clicks, to achieve this I have the following: <?php $args = array( 'post_type' ...
0
votes
0answers
40 views

Sorting posts alphabetical that have single digits

I have post titles that are like this: Episode 1 Episode 2 Episode 6 Episode 10 Episode 14 I try to list posts alphabetically but it ends up showing like this: Episode 1 Episode 10 Episode 14 ...
3
votes
3answers
96 views

What is the most efficient way of implementing a favorite post system?

I am going to implement a favorite post system so users can save their favorite posts for later reading. I want to know what is the best approach for doing it taking into considaration the ...
0
votes
2answers
1k views

Get the_field of Advanced Custom Fields in a custom query [closed]

I have a custom query to display content of a certain template: <?php $i = 0; $pages = get_pages(array( 'meta_key' => '_wp_page_template', 'meta_value' => 'sale.php' ...
0
votes
1answer
70 views

“Where… like” query not working as expected

I have the following query: $results=$facilities=$mydb->get_results("SELECT facility_name from facility where facility_name like '%".$facility_name."%' LIMIT 0, 10"); It is not working ...
0
votes
1answer
81 views

WP_User_Query. Whats wrong with 'relation' => 'OR'

I want all the users who meet either Condition1 OR Condition2. Sort by last_name. If I take condition1 AND condition2 ('relation' => 'AND'), the query is OK. If I take 'relation' => 'OR', I get all ...
5
votes
1answer
95 views

Is there any difference between hooks posts_where with posts_join and posts_search performance wise?

I want to know which filter hook I should use that performs faster. I did try both several times and I noticed that posts_search is a bit faster than using the combination of posts_where and ...
0
votes
0answers
72 views

Handling Massive Amounts of Data in a Wordpress Plugin

I've been working on my own version of a Youtube Post Importer plugin for Wordpress and I've run into a bit of a wall. I'm using the 3rd version of the Youtube Data API seen here ...
1
vote
1answer
222 views

Add Custom Post Type to Current Query

I'm trying to create a plugin which adds a new custom post type and it should be shown at the same locations as a normal post (front page, archives etc.). Is there any functions for me to retrieve ...
1
vote
1answer
216 views

convert custom query to wp_query

I have used classipress theme My query is as below $querydetails = " SELECT wposts.* FROM $wpdb->posts wposts INNER JOIN $wpdb->postmeta wpostmeta ON wposts.ID = wpostmeta.post_id ...