A generic term referring to the process of retrieving information from a database.
0
votes
2answers
72 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
141 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
62 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
270 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
145 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
55 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
350 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
85 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
117 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
75 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
99 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
43 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
63 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
1answer
188 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
191 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
115 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
36 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
46 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
186 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
99 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
96 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
99 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
84 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
61 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
1answer
240 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
57 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
181 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
797 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
172 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
214 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
91 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
221 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
100 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
56 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
362 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
68 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
62 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
159 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
282 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
1answer
152 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
145 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
37 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
83 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
86 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
124 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
1answer
933 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 ...
1
vote
2answers
199 views
Order query by post meta value
//Displaying latest post per author on front page
function filter_where($where = '') {
global $wpdb;
$where .= " AND vipwp_posts.id = (select id from {$wpdb->prefix}posts p2 where ...
0
votes
1answer
101 views
WordPress post type “event” query string fix?
What am I doing wrong in this query? I want to select events from a custom post type called events and order by the event date and only show ones after the current date. It doesn't seem to work...
...
1
vote
1answer
72 views
Add post_type to index.php
I search for an hour now without result. Does anyone can explain me how to show my custom post_type (dictionnaire) in the homepage (index.php). I use 'Easy post type' to add custom post types and I ...
