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

learn more… | top users | synonyms

1
vote
2answers
24 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
12 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
2answers
362 views

Get ID of child from child slug, while knowing parent ID

I have a hierarchy that I need to get data from. It's the child (by slug name) that I need to get while already having knowledge of the parents. Highest Known Parent Page (slug : 'parent') |_ Child 1 ...
1
vote
0answers
30 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
18 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 ...
2
votes
1answer
2k views

order by numeric value for meta value

I have read countless posts on ordering data by numeric value ( as opposed to string - it i have a numeric meta value and it gets ordered like this 1 11 12 2 233 etc as opposed to the way i want it I ...
1
vote
1answer
514 views

How to reduce the number of queries?

I have meta key "Due" for posts....if a post has expired (past the current date or not equal to it) then it will not be displayed in the count. This is my code, which works perfectly. My only problem ...
0
votes
1answer
16 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 / ...
0
votes
1answer
779 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 ...
-1
votes
0answers
10 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
1answer
620 views

Load more posts with multiple queries

I've been developing a theme which uses the load more ajax plugin, everything is setup and working great with the main query. But, once I setup a new query for popular posts, the load more posts ...
0
votes
1answer
19 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
24 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
33 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
359 views

Query set using tax_query with relation 'OR' modifies category object?

(Update: Please see the edits far below.) The code: function itsme_better_editions( $query ) { if ( $query->is_category() && $query->is_main_query() ) { $query->set( ...
-1
votes
0answers
19 views

How to add a query string to all url of a page category (woocommerce shop category)?

I need to display by default the list view activated by the query string "?product_view=list" only in certain category list pages of my choice (es: ...
0
votes
0answers
9 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 ...
2
votes
1answer
346 views

Custom Post Type order by modified date and custom meta field issue

I'm creating a plugin with some kind of offers that users can publish. User, in his custom administration panel, can managed his own offers. Offers are free and premium. If offer is premium it take ...
0
votes
1answer
4k views

Get the number of rows from $wpdb->get_results not working

I want to count the number of rows of this custom wordpress query and it does not work: *PS I am accessing a custom table inside my wordpress database, mabe by myself. The $wpdb->get_results part ...
-1
votes
0answers
14 views

Anyone know how to create comparison table with filtering? [closed]

The thing that I want to do is something like this: Comparing product features The visitor want to compare two product at the one time: iPhone 4s Vs iPhone 5s --> will show up 2 table side by side ...
-1
votes
0answers
22 views

Getting Position of a post in a category with order ASC / DESC

I need to know if is there is a way to order DESC regarding this topic. Getting Position of a post in a category
0
votes
2answers
600 views

Custom MySQL Query for Post and Post Meta

I have a custom table called "tags" that contains a charity_id that is a reference to a post ID ... I need to query the "tags" table to grab this charity_id and then pull in the post title and a few ...
0
votes
0answers
17 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
86 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
32 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 ...
2
votes
2answers
190 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
1answer
15 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
2answers
501 views

How to exclude custom fields from search queries?

I'm building a hotel search engine and I've first created a custom content type "hotel" with Types & Views Toolset. I'm using "Search everything" plugin to query custom fields and custom taxonomy ...
1
vote
1answer
439 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
43 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
22 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
448 views

SQL to update custom post taxonomies

I have a custom post "review". It uses the same categories and tags from default posts, so they share "category" and "tag" taxonomies. But later I changed the "review" register to have their own ...
-1
votes
0answers
10 views

WooCommerce - Product counter in categories on basis of tags

I was working on woocommerce and I am stuck at filtering the categories on basis of tags on products under that category. I have edited my category page to show all tags as filters now I want to ...
0
votes
3answers
60 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 ...
0
votes
1answer
20 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
30 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 ( ...
1
vote
2answers
314 views

pre_get_posts : 'post__not_in' doesn't work with global variable

I'm trying to set a post__not_in which use a global $popular variable, defined in the index.php. -index.php- $popular[] = 1 //post id=1 $popular[] = 2 //post id=2 $popular[] = 3 //post id=3 ...
2
votes
2answers
56 views

Slow wp_enqueue_media()

I have developed a WordPress plugin for my site that utilises the WP Media uploader to store files... To do this my plugin contains the following code: function enqueue_scripts() { ...
234
votes
7answers
83k views

When should you use WP_Query vs query_posts() vs get_posts()?

It seems like half the tutorials in the Codex and around the blogosphere use query_posts() and half use WP_Query. What's the deal?
0
votes
3answers
1k views

How to delete all posts, categories and tags from Wordpress database

I have WP website with over 40,000 posts. Now I'll like to delete all posts, categories and tags. So All content and related meta. All I want to keep is static files. Is there a easy way to do this ...
0
votes
1answer
453 views

Random Category with Recent Post Title and Thumbnail

This code below works perfect to pull the title of five random categories, the issue is for each random category I want the latest post title and thumbnail but where and how do I add the post query? ...
1
vote
1answer
16 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
2k views

Get category slug and display it on a query_post

I just read "How to create option page for wordpress theme" in wp.tutsplus.com - I have a problem with getting categories . there is two parts to my question - Part A - Get category slug and ...
10
votes
7answers
48k views

What SQL Query to do a simple find and replace

Whenever I create a new website I first create a staging site on a subdomain like "stage.domain-name.com". After everything works correctly I export the database, open it in notepad++ and do a ...
-1
votes
0answers
8 views

how would i generate two drop down boxes to select an outcome?

I'm trying to create a product page, and I want it to have two drop down boxes to select the finish of the product and the length.(e.g eBay have a quantity and color) Both of these outcomes have a ...
0
votes
0answers
13 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
21 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
24 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
31 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 ...