A generic term referring to the process of retrieving information from a database.
0
votes
1answer
295 views
Wordpress query unique post meta - finding all of one value without duplicates for a drop down
My wordpress posts have a city/state combo in the post meta.
I want to create a list of cities with published posts from the post meta.
How would I go about this?
0
votes
1answer
184 views
How to query an out put value?
I have this custom query that Im working on and I need to be able to query output values as well as actual stored values.
Example:
$string = "This is #*&^% a test";
$string = ...
1
vote
1answer
395 views
Is it possible to have pagination with an offset loop?
I am developing a blog page that requires 3 different post styles (Ie; one full page width with featured image and content, one full page width without featured image and the rest are half page width) ...
0
votes
1answer
421 views
Posts 2 Posts: query connected — orderby problem
Using Posts 2 Posts plugin I've created 'piece', 'person' and 'collection' custom post types: any piece may be connected to person (with roles 'author', 'conductor' etc) and collection.
Now the ...
1
vote
1answer
495 views
Wordpress Search Filter Only for Page with Child of Child of Child of Child of Child
after browsing question from this site I found the workaround for this:
function SearchFilter($query) {
if ($query->is_search) {
global $post;
$query->set( 'post_parent', 21 ...
0
votes
1answer
216 views
How to add a Variable to post query
the query is :
<?php
// Headlines variable can control admin area
// Its like ; 3,4,5,6
$headlines = ".get_option('t_turmanset').";
query_posts( array( 'numberposts' => 4, 'post__in' => ...
0
votes
1answer
324 views
How to include post count in this “get_tags” snippet
Can anyone tell me how I can show a post count in this code snippet?
<?php $tags = get_tags();
if ($tags) {
foreach ($tags as $tag) {
echo '<li><a href="' . get_tag_link( ...
0
votes
1answer
233 views
Only show content slideshow if “slideshow” custom field exists
I am developing a theme for general release and there is a large content slideshow on the homepage.
I have included a checkbox meta box in the post edit screen that allows users to determine which ...
0
votes
2answers
199 views
bulk post_content update
I need to replace all post_content in a particular tag/category to the desired one i have. is their a plugin to accomplish it or is their a query to finish this. Iam sick of doing this manually, is ...
1
vote
3answers
171 views
query in category.php repeats itself
I'm need some help on my query.
I'm building up a category page where on top a post need to show where custom field key 'uitleg' has value 'ja'. Per category there is only one post with that value. ...
0
votes
1answer
245 views
create a link to a random post within the current category
I've got some code which creates a nice link to a random post - any way to amend it so that on a category page it selects a post from the current category?
thanks,
<?php
$randomPost = ...
0
votes
1answer
447 views
How to count get_users query?
I have been searching high and low for a way to count the amount of results from a get_users query.
Most of what I found is to count the total number of posts in a post query, but nothing for ...
0
votes
1answer
958 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
2answers
319 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
389 views
How to rename a custom field?
I have 3000 posts with that custom field name 'refer' and i need to change it to 'ref' for theme needs, instead of doing it manually i need a query or technique to change them all.
Question 1
I am ...
1
vote
2answers
211 views
Tricky WP Query
I am trying to use wp_query (or another native Wordpress query class) to do the following:
get all posts WHERE
( post_type = 'post' AND category = 7 ) OR
( post_type = 'case-studies' AND meta_key = ...
0
votes
1answer
509 views
Searching with Multiple (Parallel) Criteria on Custom Fields?
I'm just an basic Wordpress user. I need to make search box with multiple criteria inputs (multiple conditions) to search inside various Custom Fields.
For example including following Custom Fields:
...
1
vote
2answers
2k views
How to use a custom post type as front page?
I would like to set a site's front page to be a single post from a custom post type. I have been able to alter the request for my front page to a Custom Post Type archive with the following code ...
0
votes
2answers
121 views
Best Query for blog posts
I am not getting any headway in this one problem I have a separate homepage from the normal blog page. However the site needs a blog so How do I structure a query that will display something like the ...
1
vote
2answers
838 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 ...
0
votes
1answer
181 views
Query specific Pages
I wonder if someone would know how to query specific pages (not by id), lets say I create a custom field called "product", and I would like to query all pages with that custom field.
Any Help?
Kind ...
0
votes
1answer
141 views
If more than 1 image show post link?
I have an image gallery of sorts its displayed on the page using the following template code...
<?php
$featured = get_post_meta($post->ID,'_thumbnail_id',true);
$attachments = ...
0
votes
1answer
121 views
Form Data Causes “Page Not Found”
If you go to http://redoakchrysler.net/vehicles/new-vehicle-inventory and select 2012 from the drop down menu in the years list, you will be taken to a 'page not found' page. But if you select any ...
0
votes
2answers
313 views
Display latest post from Wordpress Featured Category that is also in X,Y,or Z categories
I want to display the latest post from a "featured" category (id=1) that may also be in either X category, Y category, or Z category (id=2,3,4 respectively). Note, there are other posts in categories ...
4
votes
1answer
376 views
Why does `get_permalink()` produces an add. DB request without $post->filter?
I'm currently working on a custom loop/query where I need to add the permalink of a post to the array of posts I'm retrieving from the DB.
Sadly get_permalink() produces one additional DB request ...
0
votes
1answer
532 views
How to query posts by month based on date custom field?
I currently created a custom field for a custom post type that stores a date in the format dd/mm/yyyy is there a way to query the posts by the month?
I "kind of" got the functionality I need using ...
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 ...
0
votes
1answer
490 views
Get the ID of the latest post
Been all over looking for the best way to do this.
I want to get the ID of the latest post of a certain post_type.
How can I do this in the cheapest way possible (by cheapest I mean using the least ...
0
votes
1answer
172 views
Query posts WITHOUT a custom meta field
I'm trying to build a custom query that will return all posts that DON'T have the associated post meta. I'm not quite sure how to do this...here is what I am working with, and for your reference ...
0
votes
1answer
65 views
When I press home on my menu it goes to 404 page not found [closed]
On wordpress my home page went to 404 page not found,I made my home page static, and my blank page posts, but that didn't work>
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
1answer
132 views
Custom query Custom-Post-Types creates error
I created a custom-post-type for members of a firm. On the start-page I tried to call them via custom query but it shows an error. Heres my code: http://pastebin.com/rRzNcqPP and the error says: Call ...
1
vote
2answers
194 views
Query all posts which do not have tags assigned to them
Is there a way to query posts which do not have tags assigned to them?
query_posts('tag='tag_exmaple'&posts_per_page=-1');
Ty very much!
0
votes
1answer
101 views
Code in custom widget queries all posts, when it should only query the current post
I have a query in a custom widget (my first one!) which, if it's of custom post type book, retrieves the post ID. This then gets used in a WP_QUERY to retrieve data about the page.
This works ...
0
votes
2answers
763 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
245 views
Get current taxonomy and display query accordingly
Okay i'm having a bit of a catogorisation/taxonomy/filtering problem here and am at loss on how to solve this.
I hope someone could help me on the way a bit.
Say I've got a blog about food, with a ...
1
vote
2answers
313 views
Conditional custom field query
I'm working on a job board-type site, and the client want to sell featured posts. They want the featured posts to expire from showing up in the "featured" section after a predetermined period of time, ...
1
vote
1answer
695 views
Using ajax with paging and a custom sub-query
I have a page that uses three queries to retrieve a variety of content. One of those queries grabs posts that are related to the topic of the page. Since these posts can be of all sorts and related ...
1
vote
1answer
1k views
Wordpress 3.2 query_posts and pagination, permalinks issue
My question is not new but it just does not work with all found solutions in my case.
I am trying to display recent posts on single post using custom query_posts loop. The permalinks structure must ...
1
vote
1answer
673 views
$wpdb doesn't appear to work on page inside of a plugin
I have a plugin folder foobar.
Inside this plugin I have a page called foobar.php. Inside this page I have
global $wpdb;
$orderby = (!empty($_REQUEST['orderby'])) ? $_REQUEST['orderby'] : ...
0
votes
1answer
407 views
Add custom post type to query
$saved = $wp_query; query_posts(array('tag__in' => $tag_array, 'showposts' => $args['posts_per_page']));
I need this to query standard posts and a custom post type called "property"
I can't ...
1
vote
1answer
134 views
Help with Wordpress Query
I'm sort of a noob when it comes to Wordpess; I've only recently started building themes and I've run into a wall. I'm trying to feature 3 different articles at the top of my site using wpquery and ...
3
votes
2answers
361 views
Sort X categories by last update and show image
I want to display X categories, and sort them by last update.
I also want to grab the image of the latest post with the category.
<img src="<?php echo ...
1
vote
2answers
401 views
Can't pass table to $wpdb->prepare
I'm having trouble passing a table variable to $wpdb->prepare(); Here is functioning code:
$table = $wpdb->get_blog_prefix( $blog_id ) . 'my_table';
$voters = ...
0
votes
1answer
115 views
Prevent duplicate pages from being added
Im using this code to prevent duplicate post from being added but i also need to prevent duplicate pages too. Can Someone please help?
function clearDuplicatePosts(){
global $wpdb;
$prefix = ...
0
votes
1answer
144 views
Conditional Tag Custom Querys?
I think thats what its called...
Basically a conditional statement if there are any posts in a specific custom post type/custom taxonomy, show posts, it not show an img or include whatever…?
But ...
0
votes
1answer
360 views
How to display content from external db with relevant urls
I am working on a website that needs to display information about electronic resources which is stored in an external database. This information will be presented three different ways (alphabetical ...
2
votes
1answer
618 views
query multiple taxonomy and show post count
I have custom post type 'Product',
and 2 custom taxonomies 'category' and 'product status'.
What i am trying to do is list categories in page template and show how many total products in category ...
0
votes
1answer
523 views
Formatting a date/time returned from a custom $wpdb query
I'm definitely a rookie WordPress/PHP developer, so please forgive ignorance :-)
Q: How do I format a date/time returned from a custom query against $wpdb?
Here's the scenario: I'm trying to write a ...
0
votes
1answer
116 views
Query pulling a single post per month
I am trying to only show a single post per month on a query.
I can set the date as a variable and use something like the php array_unique function to check the dates and only echo out unique ones, ...
