Tagged Questions
0
votes
1answer
41 views
How to display only one category in a custom post type?
I have a custom post type called 'portcat' and I want to display the results of only one portcat category ('games' - which has an ID of '3') on my page. The below code displays all of the categories ...
0
votes
0answers
59 views
Custom query on Wordpress custom table
I am working with a custom table where some values will be inserted or updated if they already exists, I have checked and rechecked the syntax and it seems to be working fine, if I run the same query ...
0
votes
0answers
47 views
Special Query: Title, Terms, Content - %LIKE%
I'm working on a them theme that is search-heavy, and my users are putting huge priority on an improved search function.
I think I will have to use a special direct query to search these things:
...
0
votes
0answers
27 views
Get Related Posts (custom post type) of Custom Taxonomy, Most to Least?
I'm working on an image page feature which retrieves the MOST related posts ("image" custom post type). So images with most terms in common should be listed first. But this does not seem to be ...
1
vote
1answer
44 views
Wordpress Custom post query sorting does not work
I created a custom WP query to collect products that have 3 different taxonomy values in them and sorted them by price using the following:
$my_products = new WP_Query(
array(
...
0
votes
1answer
195 views
Load more posts with multiple queries
I've been developing a theme which uses the load more ajax plugin, everything is setup and working great with the main query.
But, once I setup a new query for popular posts, the load more posts ...
0
votes
2answers
138 views
SQL query to get posts from multiple categories but not in a category
I need to get the last posts' ID and the post_tile within categories 1 and 2, and exclude those within category 3. It must be SQL, because if I use WP_Query it retrieves too much info and I only need ...
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` ...
1
vote
1answer
266 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:
...
0
votes
1answer
73 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
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
1answer
41 views
Custom Query for Taxonomy
What is the correct wpdb custom query for this:
taxonomy=pa_main-genre&post_type=product&orderby=name&order=asc
Basically i am trying to do is,list all the terms for pa_main-genre. ...
0
votes
1answer
92 views
Recent activity query WordPress
Does anyone know how I can get a list of posts based on their recent activity? Activity such as a new comment, an edit, a new post, et cetera.
Some Q&A wordpress themes seem to be using this but ...
2
votes
1answer
1k views
WordPress Paginate $wpdb->get_results
Due to a complex multisite config, I have a query which combines the posts from two blogs and I would like to paginate the results. I am grateful for any help. I have posted my query.
...
0
votes
1answer
62 views
How can I add more code to this?
<?php $my_query = new WP_Query( "cat=11&posts_per_page=1" );
if ( $my_query->have_posts() ) {
while ( $my_query->have_posts() ) {
$my_query->the_post();
...
0
votes
1answer
348 views
Custom SELECT Query With Multiple Meta Values (Ordering Problem)
I have two custom meta values that I am using for an events list and have almost got everything working perfectly except for the ordering. I have two dates (event_date and event_enddate). One of these ...
0
votes
1answer
414 views
How to query term_id of a Custom Taxonomy by name
I have created a custom taxonomy "Birthday" within which i have created various dates like "December-12", "April-15"
How to get the term_id of the "December-12" by a query.
Thanks.
0
votes
1answer
220 views
query usermeta from custom field
I am using a plugin to create custom fields in the user registration.
I have created a check box field called g300 which is the name of the meta_key stored in wp_usermeta.
It looks like the value ...
0
votes
3answers
235 views
Custom Select Query - Selecting the Year?
I have a query were I'm grabbing all post types of "news" in 2010, but it doesn't select the posts from that year. What am I doing wrong?
$querystr = "
SELECT $wpdb->posts.*
FROM ...
0
votes
1answer
183 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 = ...
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:
...
0
votes
1answer
333 views
Trying to exclude custom posts based on date, while sorting by custom field
I have a custom post type named "performance". I have a custom post query that orders posts by a custom field value (order-date). Now I want to exclude posts that have order-dates that are in the ...
0
votes
1answer
389 views
Query Multiple Custom Taxonomies
I registered 2 taxonomies: festival_year and art_genre. I would like users to search for a specific year and genre but am not sure the best way to do this.
I have tried various plugins but none have ...
0
votes
2answers
143 views
custom post-type query just returns two posts
I'm making a custom activity calendar for a client here: http://arbeidshesten.com/aktivitetskalender/
The backend is a custom post type "aktiviteter", with custom fields for the date ("dato") and ...
0
votes
1answer
277 views
How Can I Always Display A Particular Post First Using WP_Query?
My apologies if this question has already been asked somewhere else, I searched but couldn't find anything. I am working on a tours website, there will be individual package pages that show some text, ...
0
votes
1answer
89 views
Number of posts in the archive
How do I show 10 posts on the first page of the archive, and 20 on others (>1)?
My custom post type name is "apartments".
Cheers!
0
votes
1answer
271 views
Prioritising and Ordering Posts By Category Name Using A Custom Loop
I have a custom loop pulling out videos all assigned to various categories. However there is a category called "new-video" and I need to pull out all videos using my custom loop, but I would like the ...
1
vote
2answers
1k views
Adding Variables to post query
How do I add custom variables to the wordpress query without having to hit the database twice. In the example below I want to add some meta filters. All this code works fine but I have been running ...
0
votes
1answer
32 views
Is there a (preferable built-in) way to check what custom queries are used in a theme?
I've build a theme using custom post-types with queries like
$my_custom_post_type_query = new WP_Query( array( 'my_arg' => 'value' ));
Now I'm writing a plugin where I need to do something like
...
-1
votes
1answer
1k views
Multiple Category Query
Is it possible to display a wordpress category page but have it pull posts from mulitple categories?
For example, let's say I need to pass in params for cat_id in this fashion
...
-1
votes
1answer
166 views
Add content in between of foreach
I have the following foreach witch gets all the content in several groups. I am using Magic Fields.
<?php $omtaleseksjoner = get_group('Seksjoner');
foreach($omtaleseksjoner as $seksjoner){
...
0
votes
2answers
915 views
Display posts separated by Category in Author's page
I created an author's page using:
<?php
if(isset($_GET['author_name'])) :
$curauth = get_userdatabylogin($author_name);
else :
$curauth = get_userdata(intval($author));
endif;
?>
...
