List of posts by day of the week

What about using just get_posts (removing the order_by argument), then looping through to create and array of programs, then building the output from that:

$posts = get_posts(array('post_type'=>'programas','meta_key'=>'audio_date'));

$programs = array();
foreach ($posts as $post) {
    $days = get_post_meta( $post->ID, 'audio_date', true );
    // $time = get_post_meta( $post->ID, 'audio_time', true);
    $found = false;
    foreach ($days as $day) {
         if (!$found) {$programs[$day][] = $post; $found = true;}
    }
    // foreach ($days as $day) {$programs[$day][$time] = $post;}
}

// start at today, loop for 7 days
$today = date('w'); 
for ($i = $today; $i < ($today + 7); $i++) {
    // fix to the actual day if value is over 6
    if ($i > 6) {$day = $i - 7;} else {$day = $i;}

    // could do this bit programmatically too
    if ($day == 0) {$daytitle = "<b>Sunday</b><br>";}
    if ($day == 1) {$daytitle = "<b>Monday</b><br>";}
    if ($day == 2) {$daytitle = "<b>Tuesday</b><br>";}
    if ($day == 3) {$daytitle = "<b>Wednesday</b><br>";}
    if ($day == 4) {$daytitle = "<b>Thursday</b><br>";}
    if ($day == 5) {$daytitle = "<b>Friday</b><br>";}
    if ($day == 6) {$daytitle = "<b>Saturday</b><br>";}

    if (isset($programs[$day])) {
        $output .= $daytitle;
        foreach ($programs[$day] as $time => $post) {
            $output .= $post->post_title;
            // $output .= " (".$time.");
            $output .= "<br>";
        }
    }
}

echo $output;

Of course, there may be another level of sorting complexity needed if you wanted to display the program times also, for now I have added some commented lines for that too.

Related Posts:

  1. How to update single value in multi dimensional Post Meta?
  2. Can an array be used as a meta_query value?
  3. Archive post by meta value + 24hours
  4. Grouping posts by a custom meta value
  5. Transaction when using WP functions rather than vanilla SQL?
  6. Sorting list of sites from multisite network using wp_get_sites
  7. How to store the_title() into a variable to reutrn the value, not just echo it
  8. How to auto login user again after change user_login
  9. count number of user comments with a specific comment meta value
  10. WooCommerce – Customer Order History Pagination
  11. How can I set custom order use this function
  12. Using a javascript file to access a get posts array
  13. my function doesn’t return my post from today
  14. Generate an array of parent/child page IDs, based on parent page name
  15. How do I dynamically generate args for wp_query?
  16. Check if term object is in array
  17. Working with query_posts ( arrays and query strings)
  18. Get Current User Id Inside a Loop Returns 0 For a Shortcode
  19. Remove duplicates – array_unique()
  20. Transferring working local PHP site to wordpress – with database (MySQL)
  21. how to delete 30 day old data using PHP [closed]
  22. Recent posts with featured image or fallback image with permalink
  23. WP Query with custom Shortcode
  24. Storing Array from returned database query and using the array in a new query
  25. Detect session/cookie variable in wordpress to prevent access to documents
  26. Querying wpdb using PHP
  27. how to fix error “called incorrectly, should not be accessed directly”?
  28. Exclude posts based on meta value
  29. Set Order Status to Complete After Payment – from another site
  30. Alter required message using comment form api
  31. Advanced Custom Fields – display label and value only if value entered
  32. Omit custom post type from wp-sitemap.xml based on meta key using wp_sitemaps_posts_query_args
  33. wp_force_remove_style’ not found
  34. How can I access string value in an array?
  35. How to array only one key from another array
  36. Filtering a function’ output for a new continued function
  37. Display all pages – in order
  38. Why is an array created in a function hooked to customize register populated when customizer is loaded but not when the front-end is loaded?
  39. last_name + first_name orderby with meta_query [solved]
  40. How to say if meta_value is greater than 0 in an array?
  41. If Array Values Match Another Array’s Values, Then
  42. WordPress loop by meta key that is an array? and how loop multiple arrays
  43. PHP -> SQL Query with Summing
  44. How to hide posts of a specific custom category in WordPress?
  45. I’m unable to call img path using single quotes in an array?
  46. WordPress meta_query >= &
  47. Order BY Most Liked And Published Between Previous Week Monday And Next Week Monday
  48. Comapare get_user_meta value
  49. How can get all users by current user meta?
  50. Get the id of all images in a post
  51. Output category list inside array
  52. Separate array output into a
  53. Update value of a associative array with update_post_meta
  54. How To Pass Array To get_the_category_by_ID() and Get An Array Back?
  55. Remove password protection from all posts
  56. Add custom fields from different posts
  57. WP_Query: How to get results from both meta_key options?
  58. MySQL Query Returns Array () In Shortcode
  59. Isn’t Returning Value While Using SELECT COUNT(*) FROM {$wpdb->prefix}
  60. Database SQL query error
  61. WordPress SQL Prepare
  62. Is it possible to order posts using multiple meta queries, i.e. show posts from first meta query, then the second?
  63. Sending simple variable on single page to WP JSON
  64. in_array not working on dev server but works on localhost
  65. meta_query search names when they have middle initials
  66. Run a sql (update) after 12 hours after the user login. Woocommerce users
  67. How can I change the background color of divs dynamically (depending on an order-status in woocommerce)?
  68. How to display MySQL table data which is stored as an array?
  69. WP_User_Query Orderby Not Working
  70. Collect all events in one year
  71. Show the subcategory name based on current product
  72. How to filter specific element of an array in wordpress/php?
  73. Notice : Array to string conversion on array_intersect user meta
  74. Remove item from post_meta array via AJAX
  75. Fatal error when using array_diff() function inside of wp_update_nav_menu hook?
  76. PHP array to jQuery array ” Uncaught SyntaxError: Unexpected token < "
  77. Getting error in sql query
  78. user update profile for custom code
  79. Display posts using post ID’s in an array
  80. Front end/Database connection in WP
  81. Display a single row from nested array of custom field data
  82. SQL Query Search page
  83. can’t delete a row from post_meta table
  84. Reformat data within a nested array
  85. How to find the function which is outputting Array
  86. Create Customization Controls from Array
  87. How to export database correctly for local to online
  88. !in_array doesnt recognize category
  89. Showing all post from all post type in admin backstage
  90. How to set if meta_value is lower < than other meta_value in a get_posts array?
  91. Populate checkboxes from array
  92. PHP Use Declared array Variable inside already Declared Array
  93. Why is my array_diff usage breaking things?
  94. save array of objects with update_option
  95. get second ID from array
  96. How to initialise WP_Query on the basis of a specific meta_value and continue iterating rest?
  97. How can I display all these movies in DESC order by modified?
  98. Replace block content with an array
  99. Adding date and time to the same request
  100. How to sort search result by post_title, then by post_content