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

learn more… | top users | synonyms

2
votes
2answers
302 views

Remove Unnecessary Mysql Query

my single posts is getting 31 query from mysql. I checked all queries. I saw this query. I am using last posts and categories widget. I think there query is unnecessary.How to remove theme Query: ...
0
votes
1answer
54 views

Make division in post_query?

I am new to both PHP and WP so I am struggling with one thing: I want to fetch all my post and then order it according to my meta-value "_mycounter" divided with the date in seconds from 1970 or what ...
0
votes
1answer
188 views

Counter code for paginated category pages in wordpress

I am trying to customize the category template whereby I wish to show the ordered list of 10 posts on each page. I am using the following code in the loop: <?php $counter = 1; ...
0
votes
2answers
124 views

Custom MySQL query to list post

I have the following query: SELECT p.* FROM orders_items oi INNER JOIN products pr ON pr.`post_id` = oi.`product_id` INNER JOIN posts p ON p.`ID` = pr.`post_id` AND p.`post_type` ...
2
votes
3answers
599 views

Remove [gallery] shortcode altogether

I used remove_shortcode('gallery'); ...the gallery is gone, but the shortcode is visible in the text. How do I remove sitewide? I've searched for sql queries, but no solution fixes my specific ...
1
vote
0answers
106 views

Changing status of Published posts which have less Content to “Draft”

function draftpost(){ global $wpdb; $prefix = $wpdb->prefix; $wpdb->query("UPDATE ".$prefix."posts SET post_status='draft' WHERE LENGTH( post_content ) <500"); } ...
0
votes
0answers
7 views

is_single query calling the wrong stylesheets? [duplicate]

Possible Duplicate: is_singular won’t call my functions? So I am trying to call different style sheets for each of my post types single page. Here is the code I am using in my header ...
1
vote
1answer
904 views

Custom search page and search by title, content and tag

Can someone review my code , I need to know better solutions or any bug. Okey ! , I made a PHP file to get search results by parameters and search by title , content and tag PHP's head look like: ...
1
vote
1answer
381 views

Recreating the hierarchy of taxonomies for a dropdown form menu?

I have a form that contains a dropdown menu. This form is on a page form.php and is not part of my theme. It exists outside of my site. This dropdown menu contains my list of values for a custom ...
0
votes
1answer
124 views

How to limit post query to only return a total count of items with certain post statuses?

I have a couple functions that are creating an admin table to display on my custom dashboard page. I'm having a little trouble with the function that determines what pages to display because I'm not ...
0
votes
1answer
646 views

Displaying Portfolio Filter by Category Order (alphabetically)

I have created a custom post type to display churches in Europe. I used this tutorial to make it filterable: http://wp.tutsplus.com/tutorials/creating-a-filterable-portfolio-with-wordpress-and-jquery/ ...
0
votes
1answer
699 views

WP_Query ordered by custom field that is a date string?

Each of my posts have a single custom field that is a string of a date (not the date of the post). Instead of my theme's current query, which orders by published date, I want to order by this custom ...
3
votes
2answers
206 views

Very slow query

This query works, but it takes upwards of 20 seconds to run on a Quad Core dedicated server... How can I optimize this? $slides=get_posts( array('post_type' => 'any', 'numberposts' => 5, ...
0
votes
1answer
113 views

Custom Query Arguments

I want to run a query base on the following $args. My question that how to pass variable number of arrays to tax_query as currently i have two arrays within tax_query it can be 1 , 3 or 5 and so on. ...
0
votes
1answer
178 views

Why posts array is empty?

I try to get posts that either do not have a custom field set or if set have a value not like a given parameter. Here is my code: $args_included = array( 'numberposts' => 1, ...
0
votes
1answer
64 views

How do I find users by password?

I need to add a passkey to each user, so I decided to just giving the user password that value and use WP functionality to store it/retrieve it. So now I need to find what user that password belongs ...
0
votes
1answer
75 views

Display old posts if no future posts exist

I have a loop setup to display future posts but would like to set up an if statement where if there are no future posts, it will show a certain amount of published posts. My current query below: ...
0
votes
2answers
723 views

Using dynamic conditions in 'posts_where' filter

I have the following code which gives be posts that are published in the last 100 days function smbd_cats_by_days ($where = '') { $where .= " AND post_date < '" . date('y-m-d', ...
0
votes
1answer
306 views

WP_Query meta compare must include ALL array values

I am allowing users to query posts using a form with checkboxes. I want the posts to be filtered by the checkboxes but instead of showing all posts that include the ANY of the meta values selected I ...
0
votes
1answer
675 views

Get 1st parent category id from post

I have this structure for my categories: Issue 4 - News - Supporting our troops - Breaking news <?php $category = get_the_category(); $parent = ...
0
votes
1answer
70 views

why the current date do not update

I'm using the following query to update fields in my table if token is matching, but the current date is not getting inserted $this->wpdb->update( 'wp_competitors', ...
0
votes
1answer
62 views

Get WP_Query query after execution?

It it possible to get the configuration of a the latest called WP_Query? I need to use it for debugging. For example, if i run something like: $the_query = new WP_Query( $args ); ... Could i get ...
2
votes
1answer
628 views

How to List Events by Year and Month Using Advanced Custom Fields?

I have a custom post type "Kalender_item" with a custom Date Field (YYMMDD). I want to list all the posts on a page sorted by Year and Month. For example: November 2012 (all events that occure ...
2
votes
1answer
197 views

List the 5 most recent child pages

I created a hierarchical custom post type for a gallery. The parent pages are the galleries and the child pages are the albums. I want to display the most recent albums on my sidebar (so basically the ...
0
votes
3answers
248 views

How to check the array values, what WP_Query has brought to me?

I have two questions in a row: How to check the array values, what WP_Query has brought to me? If I get 10 posts in cat=3, then I want to get only 5 from them, and then want to echo them ...
0
votes
1answer
184 views

How do I sort multiples pages?

I want to use a dropdown to sort a list of posts in WordPress. The results will display on multiple pages. So how do I pass the query on to the second, third, fourth, etc. pages? Here's an example of ...
0
votes
1answer
135 views

Restrict query to last day with posts

I am using the Delicacy theme. I want to show n my homepage the posts of the current day. But if there are no post for that day it shows "No found". I want to show posts from the last day with posts ...
0
votes
1answer
77 views

List related terms + taxonomies

I have a set of main categories for a set of products. All these products has additional taxonomies associated with them. On a product category page, is there a way I can get all terms in use for ...
0
votes
2answers
712 views

wpdb update multiple row?

I need to change the meta value of all users at once. Seem there are no api for this,except using custom database query. This is my code: $matches = array('meta_key' => 'user_token'); $data = ...
0
votes
2answers
77 views

list or get meta_key where meta_value is 'something'

I'm trying to get with get_user_meta the meta_key where the meta_value is 'ive-read-this' But I do not get the value. What should I do?
1
vote
1answer
415 views

Get parse_query filter to return slug instead of id

After much headache in the last week I feel like my problem is almost solved. I have been attempting to customize the admin edit.php page of custom post types to display and sort/filter custom ...
0
votes
2answers
2k views

Listing custom post types on archive page with array

I'm just starting to wrap my head around custom post types and for some reason can't get any of the custom post types to display in the loop. I've found some queries online but none of them are in ...
1
vote
0answers
275 views

WordPress Query wp-terms SLOW

I've got a very large database in WordPress with lots of products in WooCommerce along with quite a bit of taxonomies. When querying the products on the front end it takes 1 minute or more. Here is ...
1
vote
1answer
354 views

Trying to reorder posts by custom field

I'm running WooCommerce and am trying to get the default product display to be sorted by the sku field in ascending order. So far I've come up with this: /* Order products by SKU */ function ...
1
vote
1answer
135 views

Query posts from different categories in multisite

In my planed multisite installation, I want the members to be able to post in one of two different categories. Members in A can post in 1. Members from B can post in 2. All members can comment ...
1
vote
3answers
304 views

Delete post revisions on post publish

Is it possible to delete post/page revisions from the database when a post/page is published? 11/05/12 Answer: See the plugin below by bueltge I want to do this on a site with 5,000 posts and ...
0
votes
1answer
199 views

Exclude posts by post meta value

I have constructed this query to sort posts on the home page by a set position number in a custom field. However, I need to be able to exclude posts with the position set to '0'. Below is the code ...
0
votes
1answer
73 views

sql for querying post and their category

I'm trying to query the wordpress database for the post and what category they belong in. Is there a sql query that I can use for this? Thanks,
4
votes
2answers
1k views

Count & Display Database Queries

I'm looking for an solution how I can count and display all queries in a WordPress site. Does anybody know, if there is an good plugin? Otherwise it would be an solution to check the queries on the ...
1
vote
1answer
102 views

How to optimize my query filtering out unwanted data?

I use get_posts ($arg); to query the post table. Usually I need only three fields: post_title, ID and post_excerpt. But the data returned are many more, including post_content that is usually huge. I ...
0
votes
1answer
83 views

Exclude posts based on an array

I'm using a custom meta box to output a list of post IDs within a particular post type ("Publications" in this example). Is there a way I can output this array into a custom loop to only show posts ...
0
votes
2answers
374 views

Custom query object with Simple-Fields custom date field

I'm currently using the simple-fields plugin to add an event start date field that is a date type field to a custom post type called an 'event'. On my homepage I'm looking to display the three closest ...
0
votes
1answer
1k views

posts_per_page doesnt work

Here is the my custom query ; <?php $Poz = new WP_Query(array( 'posts_per_page' => 3, 'orderby' => 'date', ...
2
votes
2answers
248 views

Grouping related postmeta data via SQL query

I am using someone else's WP plugin which stores lots of related data in wp_postmeta using an "artificial key". So effectively we hijack wp_postmeta to create a nested relational database. So one row ...
2
votes
1answer
228 views

How navigation works in custom loop within shortcode?

I am using a shortcode to display a custom query. The shortcode is use in page. Everything is fine, only the navigation that I can't get it working correctly. Here is the function that I use to ...
0
votes
1answer
39 views

Showing posts from 4 categories along with all latest posts

Currently in my theme i am running the default query that pulls all recent posts/latest entries/latest published posts . But i am looking for something more complex like i am gonna setup two sections ...
0
votes
1answer
126 views

Combining two meta_values within one row with query

I've added two new meta_keys to the wp_usermeta table: bid_user_lat and bid_user_lng And I need to be able to get both of these values within a single row, along with the user_id. ROW - (user_id) ...
1
vote
1answer
137 views

Loop after page content

I just upgraded to 3.4.2 from 2.9 (i know, i know, but if it ain't broke...) I have page templates that are (or at least were) set up to display the page content first, then start a loop of posts, ...
2
votes
1answer
198 views

Show All Posts Insert Edit Link

When I click to insert/edit link in the tinyMCE rich editor for a post, then click "Or link to existing content", it shows only posts that are live and published. Is there a way to get the list that ...
0
votes
2answers
2k views

Categories and products in random order

What I'm trying to do is getting Woocommerce categories and products randomly displayed on one page. The normal settings allow to display categories and products on the same page, but first come the ...