Instead of a sql query, I recommend to do it in wordpress way: $args = array( ‘numberposts’ => 3, ‘offset’ => 0, ‘category’ => put_your_category_id_here, ‘orderby’ => ‘post_date’, ‘order’ => ‘DESC’, ‘post_type’ => ‘post’, ‘post_status’ => ‘publish’, ‘suppress_filters’ => true ); $request = wp_get_recent_posts( $args, ARRAY_A ); Reference : WordPress Update : here is the … Read more
I found solution. Grouping duplicated posts by ID. Just add this code to select query: GROUP BY wp_posts.ID Whole code (maybe it will help someone – not many examples of working pagination with select query around the internet :)): <?php global $wpdb; $date = date(“Y-m-d”); $querystr = ” SELECT * FROM wp_posts JOIN wp_ftcalendar_events ON … Read more
Errm… $item_1 = $records[0]; $item_2 = $records[1]; $item_3 = $records[2]; // e.g. echo $item_2->answer_time;
Perhaps you can add a hidden field to the HTML which will pass the ‘relation’ => ‘OR’. <input type=”hidden” name=”tax_query[relation]” value=”OR”> <select name=”tax_query[][country]” multiple> <option value=”united-kingdom”>United Kingdom</option> <option value=”ireland”>Ireland</option> </select> <select name=”tax_query[][type]” multiple> <option value=”director”>Director</option> <option value=”partner”>Partner</option> </select> Which translates to: tax_query[relation]=OR&tax_query[][country]=united-kingdom&tax_query[][type]=director Array ( [tax_query] => Array ( [relation] => OR [0] => Array ( … Read more
It’s stored in metadata, there are four meta fields: _thumbnail_id and _thumbnail_hover_id – store attachment ID, _menu_item_image_size – store selected image size, _menu_item_image_title_position – store label position, but you can get stored values from this properties: $item->thumbnail_id, $item->thumbnail_hover_id, $item->image_size, $item->title_position. Check the menu_image_nav_menu_item_filter() function in menu-image.php
look for $wpdb->last_error. It may help you to be helped yourself.
Implementing Select2 plugin into WordPress
Oh I’m kicking myself. The select fields weren’t saving because for some bizarre reason, at some point when I was working on this, their names weren’t formatted correctly, i.e. background instead of plugin-name[background]. Such a simple solution to an obvious error!
“SELECT column FROM table ORDER BY RAND() LIMIT 1 ” or you can add more restrictions to fetch from last 5 by time. Hope it help you a bit
I found a solution! As I was looking for a fix I ran across this article: https://andrux.net/add-empty-option-to-wp_dropdown_categories/ This is very close to what I was looking for, so I tweaked it. The only thing I did to the form was remove the show_option_none=Select… The form code: <form action=”<?php bloginfo(‘url’); ?>” method=”get” id=”catform”> <?php $parent = … Read more