A generic term referring to the process of retrieving information from a database.
0
votes
0answers
6 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
...
-1
votes
0answers
11 views
Displaying child categories in post
Hi I want to display all the post from the subcategories of a parent category.
There are post which are in multiple categories. But with the code below it displays post only one time even if it is in ...
0
votes
1answer
18 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
0answers
14 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
12 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
37 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
39 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
20 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
9 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
10 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
26 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
16 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
38 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
13 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
36 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
51 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
14 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
24 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
21 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
28 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
20 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
18 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
20 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
27 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
37 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
29 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 ...
2
votes
1answer
47 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
14 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
9 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
13 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
43 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
19 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 ...
0
votes
2answers
37 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 ...
0
votes
2answers
46 views
Pagination wont work with search results template
I can't seem to get pagination to work correctly in my search results template. The page links appear, but when i click onto page 2, it gives me a 404 error.
Search.php
<?php
global $wp_query;
...
1
vote
0answers
16 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
17 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
21 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
23 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
42 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
10 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
16 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
19 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
20 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
25 views
Show posts using custom while loop with pagination
I have an array of post ids i would like to show in a page 16 at a time.
The array may include some repeating ids that is why i could not use post__in in a custom wordpress query because some of the ...
0
votes
1answer
32 views
How do you dynamically display the latest events on a page using an events plugin?
I'm using the plugin called All-in-One Event Calendar, and would like to have the information of next six upcoming events to display on a specific page. I've created the page and followed the ...
0
votes
0answers
22 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
26 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
22 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
44 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 : ...
1
vote
1answer
36 views
Wordpress custom archive page
I am trying to build up a custom archive page. However, I would like this archive page to skip the first 5 posts.
I've been able to accomplish this with the offset property. However, the pagination ...
