One option is to fetch all of the posts to a single array and filter that array 50 ways. This would only generate the one query: $posts = get_posts(array( ‘posts_per_page’ => -1, ‘post_type’ => ‘school’ )); To filter your array you would do something like this: $this_state = “Texas”; $state_posts = array_filter($posts, function($results) use($this_state) { … Read more
Add generic page to WP_Query
Make sure that the value portion of the data parameter’s column=>value pairs must be scalar. If you pass an array (or object) as a value to be inserted you will generate a warning similar to mysql_real_escape_string() expects parameter 1 to be string, array given on line 880 in file /var/www/html/wp-includes/wp-db.php”. Rather then above your code … Read more
Working code: <?php global $wpdb; $date = date(“Y-m-d”); $querystr = ” SELECT * FROM wp_posts JOIN wp_ftcalendar_events ON wp_posts.ID = wp_ftcalendar_events.post_parent WHERE wp_posts.post_status=”publish” AND wp_posts.post_type=”post” AND wp_ftcalendar_events.start_datetime >= ‘$date’ ORDER BY wp_ftcalendar_events.start_datetime ASC “; $pageposts = $wpdb->get_results($querystr, OBJECT_K); ?> <?php if ($pageposts): ?> <?php global $post; ?> <?php foreach ($pageposts as $post): ?> <?php setup_postdata($post); … Read more
you must implement logic for edge cases, you could get the posts and check when was the last time their rate meta was updated! depending on that you decide if you can display or not the post on your search result
As David pointed out, wpdb::query() does not allow multiple calls. So yes, it is because of having the “SET @newnum = 0;” before your actual query. This kind of query is simply not possible as the backend prevents that in order to protect against SQL injection attacks. Besides of that, the technique I described in … Read more
I’ve solved the problem. As I was boiling my head to find another approach, I’ve seen that stato_ru column was the only one not having utf8_generic_ci encoding…
I believe showposts as been depreciated in favor of posts_per_page $args = array( ‘posts_per_page’ => 3, ‘tag_slug__and’ => array(‘morning-meat’) );
Display result from custom post meta query
It looks like you’re using a custom meta field but searching default meta attributes. https://codex.wordpress.org/Class_Reference/WP_User_Query WP_User_Query might be a more robust solution. So it would look like something like : $args = array( ‘meta_query’ => array( ‘relation’ => ‘AND’, array( array( ‘key’ => ‘mps_finaldate’, ‘value’ => ”, ‘compare’ => ‘!=’ ), array( ‘key’ => ‘mps_finaldate’, … Read more