Tagged Questions
0
votes
1answer
24 views
Custom Wordpress SQL Query 4 posts per custom taxonomy
I'm currently developing a Wordpress website that has a large navigation that lists the 4 most recent posts within a hierarchical taxonomy. I dont have any experience with $wpdb, but it seems like ...
0
votes
0answers
29 views
Order custom fields by string length
I am trying to reorder a custom field from one of my Custom Post Types.
I'd like to get the custom field string which is called 'first name' and order all of the first names by their string length. ...
0
votes
1answer
112 views
How to add a prefix to existing custom fields over MYSQL query?
I've got the problem that after a plugin update I can make the custom fields on our directory site searchable, but only custom fields which get the prefix booking_ to them.
Now there are some pages ...
0
votes
1answer
56 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
80 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
56 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
34 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
45 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
216 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
192 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
82 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
349 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
79 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
311 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
98 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
65 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
356 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
457 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
228 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
244 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
187 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
538 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
344 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
393 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
144 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
292 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
276 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
167 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
928 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;
?>
...
