Like I’ve pointed in my comment, you can find out if a ‘player’ is a ‘goal scorer’ and/or a ‘yellow/red card holder’, by comparing against their post ID. So let’s say there’s a ‘match’ with the following: 9 ‘players’ (ACF fields: pl1 to pl9) 3 ‘goal scorers’ (ACF fields: s1 to s3) 1 ‘card’ (ACF … Read more
First up, the first thing you should do is read the developer docs. This question touches on a lot of topics, and it’s not going to be possible to explain them all in one answer. Anyway, directory would be a Custom Post Type registered by the theme or a plugin. When a post type is … Read more
UPDATE Turns out the issue was with the first page of posts. I needed to account for page 1 when calling the ajax load more. Since this is a shortcode and not a template my query vars were not passing along to the ajax call. I resolved the issue by passing the page as a … Read more
You should be able to do that by joining data from wp_comments table as this table contains information about which comments belong to which posts $sql = $wpdb->prepare( ” SELECT meta_value FROM {$wpdb->prefix}commentmeta INNER JOIN {$wpdb->prefix}comments ON {$wpdb->prefix}commentmeta.comment_id = {$wpdb->prefix}comments.comment_ID WHERE comment_post_ID = %d AND meta_key = ‘rating’ “, get_the_ID() ); $results = $wpdb->get_results( $sql … Read more
The post_id column in the wp_postmeta table is a reference to the ID column in the wp_posts table. I’d suggest using the native update_post_meta() function in WordPress to update the meta data. E.g. (Post ID is 123 in this example, and we’re updating the price to 100.00): update_post_meta(123, ‘_price’, ‘100.00’); Here is the SQL equivalent: … Read more
Query posts dynamic date range
You should not modify the wordpress DB via SQL unless it is a total emergency. WordPress DB structure getting more complex with time and there are always possible intractions with plugins that you might bypass with direct SQL. What you should do is to write a small plugin that inserts the tags by calling using … Read more
You can achieve this by using Query String. First you have to make template in your theme folder. To show post list on right side and description of post on left side I am using div with class name right and left (specify your desires css properties in those classes). To show list of posts … Read more
To avoid modifying the main query, you might consider adding a custom query variable with PHP: add_filter( ‘query_vars’, function( $vars ) { $vars[] = ‘qls’; // As query-loop-search. return $vars; } ); and use ?qls=foo instead of ?s=foo. To target the corresponding query loop, add the text :query-loop-search into the search box of the query … Read more
Use WP-CLI to remove all tables from the database in MySQL. Runs DROP_DATABASE and CREATE_DATABASE MySQL statements using DB_HOST, DB_NAME, DB_USER and DB_PASSWORD database credentials specified in wp-config.php. wp db reset –yes