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

learn more… | top users | synonyms

0
votes
0answers
134 views

query by meta value then date and not empty meta value

So i have a query like this function filter_where( $where = '' ) { // posts in the last 7 days $where .= " AND post_date > '" . date('Y-m-d', strtotime('-3 ...
0
votes
1answer
122 views

query specific posts according their custom fields, using sql SELECT

My posts have a bunch of custom fields, to help insert and display custom info easily. I am trying to build a search that would select and display posts according values of specific 2 custom fields. ...
0
votes
1answer
33 views

Cannot retrieve home url with custom queries

This is just driving me crazy. I cannot get wp to return the home page/url link. I have tried various combinations of <?php echo esc_url( home_url( '/' ) ) ?> <?php echo esc_url( bloginfo( ...
1
vote
1answer
166 views

How to tune search argument in WP_Query to show only exactly the same results?

Right now I am using this: $args_search = array( 's' => $search, 'post_type' => array( 'post' ) ); $wp_query = new WP_Query( $args_search ); But the problem is that it shows ...
0
votes
0answers
133 views

Filter CPT based on meta box value using Flexible Posts widget?

I'm using the Flexible Posts Widget to display a list of "deals" (a custom post type) in my sidebar. I'm also using that plugin's capacity to use a custom template to control the display of that ...
0
votes
0answers
193 views

Adding a query var to taxonomy term archive - gets redirected to the other taxonomy archive page

I want to pass another query var in the URL through a form while I'm on a taxonomy archive page. The URL would look like so ...
0
votes
1answer
37 views

confirm my booking with phone number

I have created a booking form on front-end, and there is also "confirm my booking" page. once you submit your booking form. and it stored on "booking" custom post and saved post meta (such as phone ...
0
votes
1answer
51 views

Meta_query not filtering posts

I'm trying to filter out 'properties' on a page based on whether they are vacation or long-term rentals. Right now, the results of the following query displays all properties, not just either vacation ...
0
votes
0answers
71 views

Custom Post from Custom Query with Multiple Custom Taxonomy Terms with Pagination

I have a page template like having code, (on the link below) http://pastebin.com/mZaRLKp2 Actually it's the problem of getting custom post list having all the multiple custom taxonomy terms with ...
-3
votes
2answers
104 views

Query parsing only author ids

I need array only all author ids from the loop, each one only once if possible and out of all posts in the loop. Any suggestions?
0
votes
0answers
49 views

Wordpress can only query up to 766

Basically, I am little unaware of my WP can only run a query up to 766 custom post of one type (the actual posts). I have 26,000 posts that are within one custom post type, but cannot query them all ...
0
votes
1answer
471 views

Dynamically generated URL and Content page

I am in need of some advice. I have a section on my home page dynamically pulling in a list of terms from a custom table in the WP db. I have made a unique custom URL for each of these terms based on ...
0
votes
1answer
32 views

Show content if page is a grandchild of top level page

I'm looking to show a certain block of content if the current page is a grandchild of a top level page. This is my current page heirarchy; - Top Level Page - Child Page - Grandchild Page ...
0
votes
1answer
165 views

Set posts per page for parent category and it's all children

I am trying to use the following function to set the number of posts per page for a specific category and all it's children: function hbg_category_query( $query ) { if( $query->is_main_query() ...
0
votes
1answer
31 views

The best way to collision check in WP

E.g. I have a random number generated by a PHP code $random And I need to make a check if this number doesn't exist in any of my posts in DB in my meta field called unique_code What is the ...
0
votes
1answer
159 views

How do I use get_query_var() within plguin code

I am tring to access the author's id using get_query_var('author') , but this only seems to work on the page, not within plguin code. How do I access this from within plugin code?
0
votes
2answers
2k views

Using $wpdb to query posts with meta value containing current post_id

I am trying to to use $wpdb to retrieve a list of posts from the Database where the meta_value in the wp_postmeta table contains the current post_ID in inverted commas. eg. "10" The inverted commas ...
0
votes
1answer
179 views

display certain category on custom template page

i duplicated a portfolio column page template ... On this page I want to show only one category , instead of all categories... I tried a lot, but couldn't get it worked... this is the original code ...
0
votes
2answers
80 views

How to get posts and comments amount per hour, per year and per month?

I have this snippet: function count_user_comments_today( $uid ){ global $wpdb; $today = date('Y-m-d'); $tomorrow = date('Y-m-d', time() + 86400); $count = $wpdb->get_var( ...
0
votes
2answers
185 views

Get first comment link on the post itself

I have this function and a link to a post: <?php foreach ($results as $id) { $post = &get_post( $id->ID ); setup_postdata($post); <li><a <?php href="<?php ...
0
votes
1answer
40 views

Get query result before posts are displayed?

If I want to modify the query, I can use pre_get_posts filter. But what if I want to loop through the queried posts before they are ran through the The Loop? Is there a filter/action hook for that? I ...
0
votes
1answer
67 views

Can't get full post title if there a spaces in title

I want to make a custom query that checks the post title and puts in a different URL like this: <a href=bing.com/search?q=<?php echo single_post_title(); ?>>Blablabla</a> But it ...
1
vote
2answers
51 views

Make one query for adding entries to database

I have a situation where I need several entries to be added to a database table (sometime a few hundred), but using $wpdb->insert() (and $wpdb->update() where edits are necessary) is running ...
0
votes
1answer
78 views

Query Custom Post by taxonomy multiple categories

I need to query posts using certain taxonomy category, but more than one category of the taxonomy, as I can with posts categories.. For example, I have the Portfolio custom posts, and the Project ...
0
votes
0answers
79 views

WP_Query retrieve custom posts but not the post showing

I am developing a custom post type which shows releated posts which are within the category which is working perfect but I cant seem to get the right query to make it not show the current post which ...
0
votes
2answers
29 views

query statement containing variable won't execute

Very confused why the following code does not work. function discount_State() { if(is_page('cart')){ global $wpdb; $current_user = wp_get_current_user(); $need = $current_user->ID; $getID = ...
0
votes
1answer
514 views

Query multiple tables at once?

I want to query all of the posts in my WordPress multi-site set-up looking for a certain string. This is only being done in Sequel Pro (on the command line) for my own inquisitive purposes but there ...
0
votes
1answer
306 views

Using add_rewrite_tag to create urls for page sections

I am dividing my page templates into linkable regions. I'd like to be able to use clean urls to do so. My page urls look like so www.example.com/page-name/?section=example I'd like to rewrite the ...
0
votes
1answer
201 views

Search / Filter posts on Title/Content OR Tags

I need to make a custom query to look for posts (CPT) which match a certain keyword but it have to search posts in both the title, the content AND a custom taxonomy terms. I’ve tried with to queries ...
0
votes
1answer
84 views

Get categories of queried posts

I queried posts from an array of IDs: $args = array( 'post_type' => 'post', 'post__in' => $ids, 'orderby' => 'id', 'order' => 'DESC' ); Now I want to display a form with ...
3
votes
1answer
2k views

Using query_vars filter

I am trying to link out from the WP admin to view posts in a specific way. The url structure for this is example.com/post123/?my-preview=456 /post123/ is the regular permalink for a post. The ...
0
votes
1answer
29 views

Using class id from array for query

I'm using Event Calendar 3. Since there seems to be no easy way of querying all upcoming events as posts, I tried it this way, getting the IDs from the DB and querying the posts from that: <?php ...
0
votes
1answer
155 views

Exclude sticky posts from query

I used orderby=date and orderby=comment_count to show my recent post and popular post, but sticky post is always there on the top. How can exclude sticky posts?
-1
votes
1answer
60 views

Highlighting Sub topic in a post?

Have seen this sub topics highlighter in many blogs. It gives a special attraction to a sub topics used in the post. Is this a plugin or part of code? How can I add this? http://imgur.com/UbGpz7j
0
votes
0answers
366 views

Filter the feed page post limit

WordPress has a setting for the number of items shown in syndication feeds. I want to bypass that setting in a plugin and return a different number of items. Here's what I am doing, but it's not ...
0
votes
1answer
103 views

Delete Query won't run

This is the set up... <form method="post" action=""> <input type="hidden" name="delete_app_id" id="delete_app_id" value='<?php echo $adoptee->app_id; ?>' /> <input ...
-1
votes
2answers
457 views

How to get current user ID in array meta_value?

Here is example: $args=array( 'meta_key' => 'Something', 'meta_value' => '',//here goes current used ID by default. 'meta_compare' => '=', ); $user_query = new ...
1
vote
0answers
93 views

Post 2 Post Site Search

I'm trying to filter search terms bases on categorisation created by posts 2 posts. I'm using the generic site search and then I've created a search filter function my_filter_the_search($query){ ...
1
vote
0answers
43 views

Wordpress Query orderby title with UTF8 string in title

I got posts with titles are in utf8 encoding. When I query posts with orderby is title, those with utf8 characters at the beginning are at the end. Example: post title starts with Đ are at the end ...
0
votes
1answer
24 views

How would I get a list of posts from a custom post type

I know the query method that you would use, that's not what I want. I could query the post type, then do the if statement with the while statement and go from there, but I am trying to populate a drop ...
1
vote
0answers
48 views

Sorting main query by custom taxonomy slug

Is there a way to sort posts by custom taxonomy (shoe_color) ASC|DESC? I would like to do this using query_posts and passing the orderby=shoe_color into it. Here is the code I'm trying to work out: ...
0
votes
3answers
139 views

How to get all post_parents of a post?

Unfortunately, $post->post_parent is a single variable and not an array. I want to get all post_parents of a post (especially of an attachment, which is often linked to multiple posts!).
0
votes
2answers
18 views

How to have more post in a page than in your home page

I am new to the world of WordPress. I own a new site and I'd like my home page to display the latest news and articles (which I accomplished to set in Settings > Reading), but I'd like another page to ...
-1
votes
1answer
55 views

How to get one result using wpdb class?

function asec_get_link_color() { global $wpdp; $query = "SELECT value FROM wp_theme_options WHERE property = 'link-color'"; $result = $wpdb->get_results($sql); return $result; } ...
0
votes
1answer
108 views

Custom Query for searching through custom fields

Just wondered if someone could spare 5 mins to help me understand where I might be going wrong. I have a set of custom fields for jobs - I would like to create two drop down menus as a quick search: ...
1
vote
1answer
48 views

How can I sort homepage by a meta value?

I am trying to sort my home page posts by a custom meta value. I've been told I should use pre_get_posts but I seem to not be implementing it correctly. This is what I am doing: ...
0
votes
0answers
111 views

Order Events by Category or Type, The Events Calendar

So I've using the Events Calendar Plugin which is really working well for what I am trying to accomplish. However, I have run into a snag. I want to organize this query below by displaying an ...
0
votes
0answers
43 views

Detecting top parent category fails on home page

I have the following method to detect a top level category. But it fails on home page returning alway true. //detect parent category function in_parent_category($cats,$_post=null){ foreach ...
0
votes
1answer
64 views

WordPress Mysql query and Duplicate

i've a problem with mysql query on my wordpress database. I've custom fields Country and City. At moment I have this query that show all the cities of "UK" Country $querystr = " SELECT wposts.* ...
0
votes
2answers
288 views

Query from multiple category (and)

here is the request : get all post from category=11 (get 21 post), and then in the 21 post got from this category, refilter it, and show only post from category=10. So the request should be : ...