You don’t have any conditions for “any” as a given value in your code, so it won’t be treated as any, but as “any”. But your code checks if given value is not empty, so passing it like so should work: api.php?key=fruit,drink&value=,whiskey PS. I’m not sure if that’s the best way of passing arguments to … Read more
The orderby argument is limited by what is possible in MySQL, and it’s not good at natural alphanumeric sorting like you describe. Possible options include: Rewriting the values with leading zeros, e.g. “CA05” Creating a separate “Sort Order” column that just stores an integer, and ordering by that. Separating the letters and numbers into two … Read more
You can use the code update_post_meta( get_the_ID(), ‘_stock_status’,$value) to change the value of the meta. Please place the above line in the code where you want to change the status value and remember $value is the variable/array/object you can place any string/array/object in it.
What I don’t really understand is how or what the ‘orderby’ => ‘meta_value’, is actually sorting by as the key has multiple values. It doesn’t have multiple values. It has a single value: a:2:{s:3:”day”;s:1:”8″;s:5:”month”;s:5:”March”;}` This is a ‘serialised array’. This is just a way to store an array as a string. As far as WordPress … Read more
Thank you everyone for your help! In the end the query below got me the results I desired – which was to show and sort the posts by a custom field of “publication_date” first – sorting by the date, and if there were multiple of the same date (say, 4 marked June 2013), it would … Read more
Probably should have waited a bit but after posting the question I found a solution based on my points above and repeated here: https://codex.wordpress.org/Class_Reference/WP_Meta_Query https://generatewp.com/filtering-data-with-wp_meta_query/ My Solution: $metaSearchSubQuery = [ ‘relation’ => ‘OR’ ]; foreach($eventTypeId as $id) { $metaSearchSubQuery[] = [ ‘key’ => ‘EventId’, ‘value’ => serialize($id), ‘compare’ => ‘like’ ]; } $metaSearchQuery[] = $metaSearchSubQuery;
I figured it out… $meta_value = get_user_meta( $atts[‘owner’], $meta_key, true ); $store_numbers = array(); foreach ($meta_value as $store_number) { $store_numbers[] = ‘shop’.$store_number; } $usernames = $store_numbers;
I founded myself my searching: $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’ AND meta_value IS NOT NULL AND meta_value <> ” “, get_the_ID() ); $results = $wpdb->get_results( $sql );
Get meta_value from GDRating
If you run this query manually, you should get a response like (1054, “Unknown column ‘wp_postmeta.meta_key’ in ‘where clause’”) Long story short, wp_postmeta.meta_key is not a valid column of wp_posts. You need to JOIN the postmeta table to be able to use its columns. (There are many resources out there that explain JOIN, one would … Read more