A generic term referring to the process of retrieving information from a database.
1
vote
1answer
348 views
Sort posts based on multiple custom fields
I have a three custom fields
Meta Key → YOUR_PREFIX_newcar_body_type
Meta Key → YOUR_PREFIX_newcar_transmission_type
Meta Key → YOUR_PREFIX_newcar_variant
and I have to sort posts ...
1
vote
2answers
105 views
Query last updated posts (posts updated in the last 24 hours)
I'm having some difficulty to find an example of how to create a loop with posts that had been updated in the last 24 hours.
My idea is to have a page of posts or perhaps on the index.php a lists of ...
1
vote
2answers
446 views
Search queries don't seem to work?
I have a problem with search queries. Anytime you put additional queries, like:
mywebsite.com/?s=wordpress&post_type=page
mywebsite.com/?s=wordpress&post_type=page,post
...
1
vote
2answers
758 views
Help with MySQL to $WPDB query
Here's my issue. I have three tables I'd like to query - states, points, and state_points.
States contains stateid, and name. Points: pointid, pointlat, pointlng. State_points: Stateid, Pointid.
...
1
vote
1answer
407 views
Query get post,how to add comment box
Hello I have a query that gets a post with id=x and it works but it leaves out the comment box.
Is there a way to add "get comment box" to the query?
<?php
$post_id = 104;
$queried_post = ...
1
vote
2answers
835 views
Next & Previous (Pagination in this case) Not Appearing
I am using a custom page template for my portfolio. The code is calling the correct number of posts per page but for some reason the pagination links won't show up :-S
My query
<?php
$loop ...
1
vote
1answer
123 views
Query the post which have a thumbnail
I've got a highlight section on the header of my website which shows the title and the thumbnail of the last X posts having a thumbnail.
Is there any custom query which allows me to retrieve only the ...
1
vote
3answers
248 views
I want to create a filter for the query string is this possible?
I have spent the last few days working on and researching this question and have found no solution.
Basically I want to replace the query string which wordpress parses in order to query the ...
1
vote
3answers
419 views
Possible to filter the posts or categories that XML-RPC users see in their mobile application?
Is it possible to filter the posts or categories that XML-RPC users see in their mobile application?
I have a plugin that hooks into pre_get_posts and list_terms_exclusions to do what I need it to ...
0
votes
2answers
1k views
How can i show all categories using wp query?
<?php $recent = new WP_Query(); ?>
<?php $recent->query('cat=1&showposts=2'); ?>
With what can i replace cat=1 to show posts from all the categories?
0
votes
3answers
5k views
Using nextGen Gallery.. how can I call a list of all Gallery Names?
I'm trying to make a nav to access all the different galleries on a single page.
Instead of hard-coding all their names out. I was curious if it was possible to make this dynamic and just call all ...
0
votes
2answers
575 views
How to setup a query to output posts by groups of five?
I'd like to have a query that returns posts grouped five by five.
Right now I have a simple query loop like this one :
<?php if( $query->have_posts() ) : ?>
<ul class="posts">
...
0
votes
2answers
316 views
Exclude categories from the_category();
function the_category_filter($thelist,$separator=' ') {
if(!defined('WP_ADMIN')) {
//list the category names to exclude
$exclude = array('Something','Something Else','Blah','YAY');
...
0
votes
2answers
2k views
wp_query orderby title and meta key value (WP3.1)
I have a taxonomy wp_query and i would like to order the list by title and by meta value (numeric value)
Have a meta value Interesting = 1 or 0 in the posts
Not so interesting posts would be at the ...
0
votes
1answer
54 views
Better wordpress attachment query then this
I have a site with more then 10.000 posts and images, its classipress site. I need somehow to show all images from posts that are on pending status, and who havent expired(post meta). This is the code ...
0
votes
2answers
186 views
Duplicate posts
I'm currently working on a Magazine style website and on the main page I have three different sections where I display the latest news. Slider, latest news and more news.
The problem is I can't ...
0
votes
2answers
322 views
How to modify the query to exclude posts by slug?
How can I modify my query in order to exclude certain posts by slug?
Is it possible?
query_posts(array('category_name' => 'Mycat', 'posts_per_page' => -1));
Ty
0
votes
2answers
1k views
How to order posts by modified date without using 'query_posts'?
I have an example basic wordpress theme template here for you. First, please take a quick look at it to get an idea.
<?php
get_header(); ?>
<div id="primary">
<div ...
0
votes
1answer
449 views
mySQL query. ORDER BY meta_key
I'm fighting this quite long already and start to think I'm missing something big. CPT posts could have or not metadata ( _vip_post [0|1], _thumbnail_id [null|numeric] ).
If i query for ...
0
votes
2answers
529 views
Get Posts from Last 24 hours and Sort them via GD Star Rating
I am trying to sort the posts using GD Star Rating in the last 24 hours. I have two separate queries, but I don't know how to merge them.
function filter_where($where = '') {
...
0
votes
2answers
754 views
view queries made?
I know I can use get_num_queries() for the number of queries. However, how can I see what queries Wordpress actually makes? I've tried using $query but that didn't work.
0
votes
1answer
1k views
How to count post type that has a particular term?
What is the best method to count the number of posts in a post type that have a particular term? I don't believe get_posts accepts a term query and I have had no luck with new WP_Query, though I might ...
0
votes
3answers
439 views
Each post is showing twice in my custom query…?
I've created a custom query to pull all posts from a custom post type, ordered by comment count. It's your run-of-the-mills custom query:
<?php
$querystr = "
SELECT wposts.*
FROM ...
0
votes
1answer
29 views
Exclude all sticky posts front page twenty twelve
I am attempting to exclude all sticky posts from my front page in twenty twelve theme. I have attempted the following. I am making all changes to the child theme.
To remove the following code from ...
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 ...
0
votes
1answer
96 views
List author's posts with SQL
I want display authors'posts with the code below but authors' name aren't showing.
What is wrong?
<? // query test
$qry = $wpdb->get_results( $wpdb->prepare("
SELECT *
FROM $wpdb->posts
...
0
votes
3answers
285 views
Split wordpress loop to multiple layouts
OK so I've searched a lot and couldn't find a straight forward answer to my question.
I am simply trying to use one category loop that will display posts in a category page in a wordpress site. lets ...
0
votes
2answers
130 views
Transient api Caches confused
This code works for page 1
<?php
$paged1 = (get_query_var('paged')) ? get_query_var('paged') : 1;
$recent1 = get_transient( 'recent1' );
if ...
0
votes
1answer
649 views
$wpdb->get_var not returning a result
I launched mysql and confirmed this query returns a result:
mysql> SELECT * FROM wp_posts WHERE post_parent = 68 AND post_type = 'attachment' AND post_name = 'side-logo-auto2' LIMIT 1;
1 row in ...
0
votes
1answer
84 views
Get post ids sorted by meta_key
I have defined a post_view_count meta_key to store the number of post views.
I would like to get an array of post ids sorted by post_view_count value to use in the
functions.php file.
Thanks.
0
votes
1answer
189 views
Remove posts from query for events whose start date has passed
The query below works as expected, showing cpt event ordered by meta_value, what I haven't figured out yet is how to remove posts for past events or events which have started. The start date for ...
0
votes
1answer
120 views
Can't seem to do combined query AND sort?
Below is the code I'm using to query multi-day events. The problem I'm having is that I can either sort by the start date (evstart_date) OR I can do a combined query against start date and end date ...
0
votes
2answers
143 views
query if page has not child
I'm trying to create a page which display a few of sub pages (child pages), however if the page has not child I would like to display a message.
I cannot get a query that allow me to do something ...
0
votes
1answer
1k views
Nginx rewrite rules
I am having some problems with the Nginx rewrite algorithm for WordPress.
I am using this for the rewrite and it works good;
server_name www.domain.com domain.com;
if ($host != ...
0
votes
1answer
955 views
Problem with 'post__not_in'
I am running a custom query below each post, to get other post from its category.
Now I want to exclude the current post. This is my Query:
<?php // related_posts();
$exclude_post = ...
0
votes
1answer
82 views
querying a custom field
I'm trying to hack a plugin to show the contents of a custom field where its currently showing the title.
how would I get this to show a custom field called restaurants instead?
Thanks,
...
0
votes
2answers
1k views
Use mysql_query instead of $wpdb query
I have a custom table inside my wordpress database called test.
What if i query this table using mysql_query() instead of using for example $wpdb->get_results()
Will this affect my performance?
Ty ...
0
votes
3answers
262 views
And/Or Category Query
I'm having a lot of trouble using php query_posts(array('category__and'=>array(1,3))) - it seems to be pulling anything that's in category 1 regardless of whether it's also in category 3 and I only ...
0
votes
3answers
559 views
How to find if a post with custom_field == X exists?
I need to find if a post with a custom field X equal to Y exists in a wordpress installation.
Should I do it with a simple sql query or is there something build in that can help me achieve it?
0
votes
1answer
620 views
Query of custom post types only shows first post
I have a loop to show my custom post type of 'case_studies'. It originally showed all posts until I wanted to just show 3 specific posts. The problem is that it only shows the first post in my list of ...
0
votes
1answer
413 views
Custom query for custom post_type
I need to display a list of current tasks. Each task has a custom post_type and a start date and end date.
Can someone tell me how to modify my query so it will pick up any tasks that have a start ...
0
votes
2answers
286 views
How to get events using multiple custom meta fields?
I need to grab a list of current events. The events have a start and end date so I need to be able to select a range as opposed to just getting any list of events that have an end date that is after ...
0
votes
1answer
1k views
Adding custom field values to wp_list_pages
I am trying to pull in a custom field vales for each page while using wp_list_pages. For example I want to list out each portfolio item in my sidebar but also show why type of work it is by pulling ...
0
votes
1answer
24 views
Best practice to limit results in get_row()?
This is my query to check if a title exists (it's in a loop, therefore [$i]).
$wpdb->get_row("SELECT * FROM wp_posts WHERE post_title = '" . $titles_arr[$i] . "'", 'ARRAY_A');
Anyway, I would ...
0
votes
1answer
51 views
PHP variable in WordPress database query
When running the following code :
$voucher = 'MK0186';
$is_in_database = $wpdb->get_results( "SELECT * FROM my_codes_table WHERE code =" . $voucher );
I get : WordPress database error: [Unknown ...
0
votes
1answer
43 views
WP_Query: query posts by ids from array?
I did quite a bit of research but can't figure why this wouldn't work for me?
echo print_r($rel); // Array ( [0] => 63 [1] => 87 )
$args = array(
'post_type' => array( 'post' ),
...
0
votes
2answers
193 views
Setting get_queried_object
I know that get_queried_object contains the object that was queried for the current page. My question is, what methods of querying affect the contents of this?
For instance:
query_posts
get_posts
...
0
votes
2answers
115 views
Query custom post type based on post id and custom field value
There might be an answer here somewhere, but I'm unable to find it, or recognize it if I did. Here's the situation:
I have a custom post type, 'region', that displays on single-region.php. Region ...
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
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 ...
