mysql query paging
You need to use get_posts(), have_posts(), and the_post() for the API functions to work.
query
Does meta_query work within get_posts array?
Not possible with an empty value. See: How can I show posts only if meta_value is not empty
Listing posts by grouping dates
I’ve been using the following plugin for Event management, and it has short code to display all events and sort them by date. It also has some developer features to give you a bit more control over things. http://wordpress.org/extend/plugins/events-manager/ Very cool plugin that is actively developed.
WordPress query by category, sorted by custom field
I don’t think there’s an easy to sort by three different meta values, and really, I don’t see why you need to in this case. Why not just save the event date in one meta value and sort by that? It makes your query much more efficient (removes two unnecessary joins) and lets you use … Read more
Sort posts based on multiple custom fields
Unfortunately, I don’t believe WordPress has the ability to sort by multiple meta key criteria as part of the query: only one. This is likely because for each meta key value selected, another JOIN is involved. You can also see that there are no hooks to modify the ORDER BY clause in SQL in the … Read more
Grouping related postmeta data via SQL query
If I understand your question correctly, this should work: function get_event_info($event_id = 0, $info = ” ) { global $wpdb; return $wpdb->get_col( $wpdb->prepare( “SELECT meta_value from $wpdb->postmeta WHERE meta_key = ‘%s’ AND post_id IN (SELECT DISTINCT post_id FROM $wpdb->postmeta WHERE meta_key = ‘event_id’ AND meta_value= %s )”, $info, $event_id ) ); } Use this like … Read more
How to List Parent Term Links for Custom Taxonomy With & Without Children?
Here is some basic setup for the function that MavBzh mentioned. <?php $args = array( ‘title_li’ => ”, ‘taxonomy’ => ‘industry’, ‘show_option_none’ => ”, ); ?> <ul><?php wp_list_categories( $args ); ?></ul>
How to implement time filter to show random post 1 month for one category and 3 months for other categories
You cannot declare multiple functions with same name in PHP. Codex examples for this are technical demonstration, rather than ready-made usable snippet. Give your filter functions unique names, that are not likely to clash with your own or third party code.
Get comment content by comment ID
The Codex makes it seem like you can query for a specific comment by ID, as does the GenerateWP query generator, but I couldn’t get it to work with either of those examples. Even looking through the WP_Comment_Query:query() code makes it clear that you should be able to pass the ID in the parameters. That … Read more
Custom Post order for homepage
From a naming standpoint it seems that the term “filter” would be more appropriate since you are filtering by criteria first and then a sort (directional) is applied when you order. But that’s more a naming convention standpoint… From a code structure if you are using the check_for_popular() method in several places then it makes … Read more