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

learn more… | top users | synonyms

0
votes
1answer
11 views

QueryObject un-orders post

Hi I'm using this code below to display post from a specific category and also to style the first post different from the next 5 post. <?php $queryObject = new Wp_Query( array( 'showposts' => ...
1
vote
3answers
62 views

Check if loop has any categories?

In my loop, I have ten posts with the following categories (slug): group-a, group-a-first and group-b. The loop/query looks like this: Post (group-a) Post (group-b) Post (group-a-first) What's the ...
0
votes
0answers
18 views

Adding a term to a listing inside of shortcode that otherwise contains permalinks to custom post items with custom field values

I have this shortcode to output all items of custom post type "song", on a page listing all the songs a musician released throughout his career. // Custom shortcode, to query tracklistings on the ...
1
vote
1answer
19 views

Insert static element only once in query archive

I'm looking to insert a foreign div-element only once in a archive query on my page. So that for example: Post1 Post2 [Static Div] Post4 Post5 ...etc My query is: <?php $archive_args = array(...
1
vote
0answers
13 views

get the taxonomies terms associated with users

I’m building a search form with meta_query to get users based on meta_key and meta_value. Some meta_key are taxonomies. It works very well but in my select, i have all terms and some terms are not ...
0
votes
3answers
59 views

Is temporarily overwriting $wp_query a bad idea?

I am in the process of rewriting a lot of my code and restructuring a lot of my theme files to use template parts (i.e. using get_template_part()). I've come upon a situation where I want to use the ...
1
vote
1answer
10 views

cache specific data?

I want to display some information from database in each post, for example date of registration of user and user role etc. It is quite static data that doesn't change. Now if I make a query to the ...
0
votes
0answers
16 views

can I separate two taxonomy (category) loops on one page

I have created a staff and teachers page with custom posts and categories. I currently have them display in an archive-teachers-and-staff.php template with no filter. I am using the date to get the ...
0
votes
1answer
17 views

How to run a mysql query when admin updates user role?

I need to run a query when the admin changes the user role in the admin panel. Right now, this is my code: add_action( 'set_user_role', 'my_function' ); function my_function ($user_id){ $user = ...
0
votes
1answer
62 views

Bring a post to the top of the query if it's in a certain category?

I'm looking for a way to bring a post if it's in a certain category to the front (or top) of the list. The category is called 'first'. I don't think orderby supports category so what other options do ...
-2
votes
0answers
19 views

Hoping someone could explain some queries for me

The following queries are considerably slow on my site and I'm hoping someone could explain them to the best of their ability (what they're doing/requesting). SELECT SQL_CALC_FOUND_ROWS wp_posts.ID ...
0
votes
1answer
15 views

YearMonth datequery

I'm trying to make use of the Date Parameter 'm' which is for the YearMonth. I can't figure out what the query name is or how to use it to search for posts with it. Thanks
-2
votes
2answers
58 views

How to show posts of a specific category

I am new with word press and I want to show the post of a specific category on my page. The name of the category which i want to show is home slider. Below is the code which I have used to display all ...
0
votes
2answers
23 views

Display posts by combining multiple meta key

Basically a post is an event therefor will be displayed once or twice, depending on meta key. Every post has at least two meta keys $start_time_1 and $end_time_1. Let's say i have two posts, title: "...
-2
votes
1answer
48 views

Get Posts ordered by a date custom meta field

I have created a meta field for a custom post type. This is a date field that will always be YYYY-MM-DD. There could be 100s of posts so i cant query them all and sort afterwards. I need to be able to ...
1
vote
1answer
23 views

Search query -> Show all pages except certain template

These are my arguments for the search query: $args = array( 's' =>$s, 'post_type' => array( 'post', 'p24_cases', 'page') ); Using these arguments, the search results will show all pages ...
3
votes
0answers
44 views

How to find objects by terms

I am struggling with a search filtering. Firstly, my script is searching for users using natural search SQL. The query returns ids of users. Now I would like to filter them by terms which are assigned ...
-1
votes
0answers
24 views

What is the one-query (or the fastest) way to get posts and their terms (more taxonomies)?

Now this might seem like a similar question One query to get posts and their taxonomy terms but it is just similar and does not have proper answer. Goal: I need to get limited number of posts and ...
0
votes
2answers
42 views

Running Filter or Shortcode Before Query Prevents Excerpt from Showing

I've been wrestling with some code cobbled together for a function I found, first published circa 2009 and my inexperience with PHP has me at a loss. The function is designed to count episodes in a ...
0
votes
1answer
30 views

How to make MySQL search queries with quotes

Hi everybody I run a wordpress based website and I'd like to store the search queries called by users to use them as analytics data to know what's most searched etc... So I have a custom table where ...
0
votes
1answer
31 views

Is it possible to retrieve posts depending on meta_key LIKE condition? [duplicate]

I'm currently facing a little problem. I'm using ACF plugin which generate complex meta_key names when creating hierarchical fields. I found in my database meta_key named modules_1_content_0_module. ...
4
votes
1answer
103 views

author.php with ACF and CPTs

As I write this, I'll do my best to avoid an XY Problem. What I'm trying to do: I'm trying to build an author.php template that: displays data from Advanced Custom Fields on the user's Profile ...
0
votes
1answer
33 views

How to use apply_filters?

So I am using a plugin which loads next posts as the user scrolls down in the single.php file. Inside the main php file of the plugin, there is something along the lines of // By default, don't ...
1
vote
0answers
16 views

Alter main archive, to show posts with meta as last

I'm having troubles with getting posts with meta_value "sold" as last in the main query of my custom Post type. The best/easiest way i can think of at the moment is to filter the "sold" posts out of ...
0
votes
1answer
51 views

Query Strings and Woocommerce

I've got a wordpress website and am using WooCommerce to sell registrations for applications that I develop. To streamline the registration process, I would like users to be able to click a ...
0
votes
0answers
18 views

Dynamic URL to generate table data

I'm trying to create a page that displays a table using a dynamic URL so that I can share links to people who would only see their set of the data . Different table IDs would bring up a different ...
0
votes
0answers
13 views

Filtering search results for nested loops

So I have a list of companies that have counties and cities. I need to be able to do something like /findmanagers/miami-dade/ and then build a query that fetches all the companies we have listed ...
2
votes
0answers
35 views

my function doesn't return my post from today

I'm using gravity form to create some custom post type - as events. Everything is working great, There is some date field to setup the event from x to y date. ALl of this working great. However, I ...
0
votes
0answers
11 views

Query by attachment image size

Is it possible to use WP_Query to get attachment images by pixel size? For example all images with a width of 500px and height of 300px. Or images with a height bigger than 300px. As far as i can ...
2
votes
1answer
31 views

Taxonomy.php issue with search and filters [Solved]

I'm trying to create a custom taxonomy.php page where my users can refine search into that context. I've tried to create a kind of loop like: <?php if(!empty($_GET['ending'])) ...
0
votes
1answer
60 views

Custom query filter not working on woocommerce category page

I am trying to make custom filter for my woocommerce website. Everything is working fine in the shop page, but when I go to the archive page the filters are not working. I am recording each filter ...
0
votes
0answers
22 views

View all multisite posts from one “hub” site

I'm creating a centralized blogging network for a client. The idea is that, on one of the many sites, the client can see a list of all the posts on all the sites. The interface for this would ideally ...
0
votes
1answer
17 views

Sort Events by Venue Title - Sort Post set by related post ids

In wordpress, I am using The Events Calendar Plugin to host events. This includes two post types: events and venues. On an index page, I would like to list ALL events, but ordered by their ...
1
vote
1answer
40 views

How i can limit period of post publication?

I need to limit period od post publication - admin type date, for example, 30.05.2016 in custom fields and then i need to hide custom posts with this date less, then today date How i can do this?
0
votes
1answer
71 views

Get posts of an specific term of a custom taxonomy

I'm new at Wordpress development and I was wondering (and trying to solve this) for a long time, so maybe you can help me. My WP use a custom post type named Products. And there is a custom taxonomy ...
4
votes
2answers
59 views

Are there any scenarios where the query_posts may be used?

I feel there is a red button saying "Do not press" below query_posts(). For some time I am trying to demystify this phenomena with very low success to be honest. For example, probable the main ...
3
votes
2answers
72 views

Is `query_posts` really slower than secondary query?

I know the main query is fast, since it gets data after parsing the URL and after WP_Query has been instantiated. We are in OO PHP. But is query_posts really slower than some secondary query that ...
0
votes
0answers
74 views

Sorting Grids with Essential Grid and Events Manger

I am using Events Manager to control my Events, but Essential Grids to display previews of these events in various places throughout my site. An example of this is http://staging-dbmax....
0
votes
1answer
33 views

Query 1 custom post type, each day, alphabetically

Hoping someone can help - for some reason my brain is mush on this one and I can't seem to find a similar example via Googling. What I have is a CPT called "products" for example and what I need to ...
0
votes
1answer
24 views

how to get postmeta info based on multiple categories?

I need to get one meta_value from wp_postmeta and I can do it with one category but I'm having problem when using another one. I have: SELECT wp_posts.ID, wp_postmeta.meta_value FROM wp_postmeta ...
0
votes
1answer
18 views

orderby in WP_QUERY - Use the order from the Dashboard

I'm using the Anything Order Plugin to order custom post types in my dashboard. For a wp_query, I'd like the output to order the posts in the same order as I have them in the dashboard. What would ...
0
votes
0answers
20 views

Echo multiple tasks if a common function exists

How can I echo multiple tasks if a common WordPress function exists. For example, I want to reduce the following: <?php if (function_exists ('pluginName')) echo someName (1); ?> <?php if (...
6
votes
3answers
68 views

Random sort within an already sorted query

I have a working query which returns a set of custom posts which are ordered by their package ID (ASC). For a query with 9 results this may return for example: 4 posts (Post ID's 1,2,3,4) with ...
7
votes
3answers
297 views

Remove the Homepage Query

I have a homepage displaying the home.php template, containing 2 sidebars with widgets in them. The main query still pulls in the standard 10 posts, but since I'm not displaying these, I'd like to ...
0
votes
1answer
31 views

Show first posts with custom field not empty and order all by title

I have a custom post type called "products". My goal is to make my custom query that I have on homepage and also the search query show first the posts that have a custom field called "id_number" not ...
0
votes
0answers
63 views

Hide empty categories from get_categories

I'm trying to hide the empty categories (with no posts associated) from a list in an archive page. I'm using hide_empty as suggested on Wordpress codex but it's not working, the code outputs all ...
1
vote
2answers
45 views

Show featured image as background image from postQuery

The code below gets the image but I want it to be a background image. I believe I need to save the image as a variable first and then echo it out somehow. My PHP is not great so please give an example ...
0
votes
0answers
35 views

Custom database query with accents returning no results

I have an issue where using accents in my custom database query (wpdb) returns no results. $wpdb->get_results( "SELECT * FROM table WHERE city = 'Montréal'" ); Returns nothing, while $wpdb-&...
0
votes
1answer
37 views

Limiting a filtered query

I'm struggling with this query. I have a page where I will show products launched from last month and this current month. (http://the.nett.mx/innvictus/wp/) Everything works great, but when I apply ...
0
votes
0answers
22 views

Filter User Query via URL Like Posts

I have two taxonomies assigned to users and I use them to create a user query and output the users. One of the taxonomies is ESPECIALIDAD, the other is REGION. When I am in: mysite.com/especialidad/...