Events Page Loop

      <?php // This is the loop for quering an individual page's events and upcoming events
      $todaysDate = date('Y/m/d'); // Get today's date in the right format
      $today = date("Y-m-d 00:00");  //set today's date for upcomming events sidebar
      $lastWeek = date("Y-m-d", strtotime("-7 days"));
      $nextWeek = date("Y/m/d", strtotime("+7 days"));
      $todaytext = date("l"); // define $todaytext with written out days for upcomming events sidebar
      $todaydatetext = date("F j"); // define $todaydatetext as written month and number date for upcomming events sidebar
      $convertedtime = "g:i"; // convert to 12 hour clock and minutes for upcomming events sidebar

      $eventsloop = new WP_Query('post_type=event&location=' . $whatCity .'&meta_key=end_date&meta_compare=>=&meta_value=' . $todaysDate . '&orderby=meta_value&order=ASC'); // Displays the events that have not ended yet

      $featured_args = array(
           'post_type' => 'event',
           'posts_per_page' => '1',
           'orderby'     => 'rand',
           'meta_query' => array(
           'relation' => 'AND',
              array(
                  'key' => 'featured_event',
                  'value' => 'on',
                  'compare' => '=='
              ),
              array(
                  'key' => 'end_date',
                  'value' => $todaysDate,
                  'compare' => '>=',
                  'type' => 'DATE'
              )
          )
      );


      $featured_event_query = new WP_Query( $featured_args );
      if ($featured_event_query->have_posts()) : while($featured_event_query->have_posts()) : $featured_event_query->the_post(); // begin the loop after sorting the posts by location date and removing old end dates
      ?>

      <div class="recommended_event">
      <h1>We Recommend</h1>
      <?php
      ?>
      <h3><?php
          if (get_post_meta($post->ID,'event_venue', true) != 'other') {
              echo get_post_meta($post->ID,'event_venue', true);
              }
          if (get_post_meta($post->ID,'event_venue', true) == 'other') {
              echo get_post_meta($post->ID,'custom_event_venue', true);
              }
      ?></h3>

      <a href="<?php the_permalink() ?>" title="<?php the_title(); ?>"><?php the_title('<h2>', '</h2>'); ?></a>
      <a href="<?php the_permalink() ?>" title="<?php the_title(); ?>"><?php echo get_the_post_thumbnail($post_id, 'featured_events'); ?></a>
      <?php endwhile;?>
      </div><!-- end .recommended_event-->

      <?php endif; ?>


      <h1 class="ongoing_events">Ongoing</h1>
      <?php
      while($eventsloop->have_posts()) : $eventsloop->the_post(); // begin the loop after sorting the posts by location date and removing old end dates
      ?>
      <div class="ongoing_event">
      <div class="row">
      <div class="grid_4">
      <a href="<?php the_permalink() ?>" title="<?php the_title(); ?>"><?php the_title('<h2>', '</h2>'); ?></a>
      <a href=""><h3><?php

          if (get_post_meta(get_the_ID(),'event_venue', true) != 'other') {
              echo get_post_meta(get_the_ID(),'event_venue', true);
              }
          if (get_post_meta(get_the_ID(),'event_venue', true) == 'other') {
              echo get_post_meta(get_the_ID(),'custom_event_venue', true);
              }
      ?></h3></a>

      <?php

      $venue = get_post_meta( $post->ID, 'event_venue', true );
      echo get_related_event_data( $venue, 'address' );
      echo get_related_event_data( $venue, 'address' );
      echo get_related_event_data( $venue, 'address' ); ?>

      <?php // Format the running dates
      $startdate = get_post_meta($post->ID, 'start_date', true);
      $enddate = get_post_meta($post->ID, 'end_date', true);
      $writestart = preg_split ( '/\//', $startdate );
      $writeend = preg_split ( '/\//', $enddate );
      ?>

      <h4>
      <?php // and print nicely
      if (get_post_meta($post->ID,'end_date', true) <= $nextWeek) {
          echo '<span class="last_chance">Last Chance: </span>';
      }
      echo date('F j', mktime( 0, 0, 0, $writestart[1], $writestart[2], $writestart[0] ) );
      echo ' through ';
      echo date('F j, Y', mktime( 0, 0, 0, $writeend[1], $writeend[2], $writeend[0] ) );
      ?>
      </h4>

      <?php // Check if Opening or Closing dates exist and echo the information
      $convertedtime2 = "F j, Y | g:i a"; // convert to 12 hour clock and minutes
      $opening_time_formated = date($convertedtime2, strtotime( get_post_meta($post->ID,'opening_time', true)));
      $closing_time_formated = date($convertedtime2, strtotime( get_post_meta($post->ID,'closing_time', true)));
      $end_date_formated = date('F j, Y', mktime( 0, 0, 0, $writeend[1], $writeend[2], $writeend[0] ) );

      ?>

      <?php


      if (get_post_meta($post->ID,'opening_time', true) >= $today) {
          echo '<h5><span class="strong">Opening: </span>'.$opening_time_formated .'</h5>';
      }
      if (get_post_meta($post->ID,'closing_time', true) >= $today) {
          echo '<h5><span class="strong">Closing: </span>'.$closing_time_formated .'</h5>';
      }
      if (get_post_meta($post->ID,'artist_talk_time', true) >= $today) {
          echo '<h5><span class="strong">Artist Talk: </span>'.$closing_time_formated .'</h5>';
      }


      ?>

      <?php

      $today = date("Y-m-d");
      ?>

      </div><!-- end .grid_4-->
      <div class="grid_4">

      <a href="<?php the_permalink() ?>" title="<?php the_title(); ?>"><?php echo get_the_post_thumbnail($post_id, 'half_postcard'); ?></a>

      </div> <!-- end .grid_4-->
      </div><!-- end .row-->
      </div><!-- end .ongoing_event-->
      <?php endwhile; ?>

      </div> <!-- end .grid_8-->

      <div class="grid_4">

      <div class="row">


      <div class="sidebar_upcoming_events">
      <div id="upcoming-events" class="module module-upcoming">

      <h1>Upcoming</h1>

      <?php
      for ($i=0; $i<10; $i++) {
      $thedate = strtotime ( '+'.$i.' day' , strtotime ( $today ) ) ;
      $thedate = date ( 'Y-m-d H:i' , $thedate );

      $thedaytext = strtotime ( '+'.$i.' day' , strtotime ( $todaytext ) ) ;
      $thedaytext = date ( 'l' , $thedaytext );

      $thedatetext = strtotime ( '+'.$i.' day' , strtotime ( $todaydatetext ) ) ;
      $thedatetext = date ( 'F j' , $thedatetext );

      $future = strtotime ( '+24 hours' , strtotime ( $thedate ) ) ;
      $future = date ( 'Y-m-d H:i' , $future );
      $times = array();  // put before the $event_query and seems to work

      $args = array(
           'post_type' => 'event',
           'orderby'     => 'meta_value',
           'order'       => 'asc',
           'meta_query' => array(
           'relation' => 'OR',
              array(
                  'key' => 'opening_time',
                  'value' => array($today,$future),
                  'compare' => 'BETWEEN',
                  'type' => 'DATE'
              ),
              array(
                  'key' => 'artist_talk_time',
                  'value' => array($today,$future),
                  'compare' => 'BETWEEN',
                  'type' => 'DATE'
              ),
              array(
                  'key' => 'closing_time',
                  'value' => array($today,$future),
                  'compare' => 'BETWEEN',
                  'type' => 'DATE'
              ),
              array(
                  'key' => 'special_event_time',
                  'value' => array($today,$future),
                  'compare' => 'BETWEEN',
                  'type' => 'DATE'
              )
          )
      );

      $event_query = new WP_Query( $args );
      if ($event_query->have_posts()) : while ($event_query->have_posts()) :  $event_query->the_post();

      $keys = array('opening_time', 'closing_time', 'artist_talk_time', 'special_event_time');
      $custom_field_keys = get_post_custom_keys();

      foreach ($custom_field_keys as $custom_field_key) {
         if (in_array($custom_field_key, $keys)) {
              $custom_field_value = get_post_meta($post->ID, $custom_field_key, true);
              if ($custom_field_value >= $thedate && $custom_field_value <= $future) {
                 $counttest++;
                 $times[] = array($custom_field_value, $post->ID, $custom_field_key);
              }
          }
      }

      endwhile;
      ?>

      <ul>

      <?php
      if ($counttest >0) {
      ?>
      <li>
      <h1 class="upcoming_date">
      <span class="total">
      <?php
          echo $counttest;
          if ($counttest>=2) {
              echo ' Events ';
          } // end if ($totalevents>=2) function
          if ($counttest<2) {
              echo ' Event ';
          }
      ?>

      </span> <!-- end .total -->
      <span class="day_sidebar">

      <?php
          if ($thedate==$today) {
              echo 'Today';
          }
          if ($thedate>$today) {
              echo $thedaytext;
          }
      ?>

      </span> <!-- end .day -->
      <span class="date_sidebar">

      <?php
          echo $thedatetext;
      ?>
      </span><!-- end .date -->
      </h1>
      </li>

      <?php
      }
      endif;
      $counttest=0;

      sort($times); // I changed the asort to sort here

           foreach ($times as $event) { $time_value = $event[0]; $post_id = $event[1]; $time_key = $event[2];  // changed the foreach here

          if ($time_key == 'opening_time') { ?>

          <li class="sidebar_event">
          <a href="<?php echo get_permalink($post_id) ?>" title="<?php echo get_the_title($post_id); ?>"> <?php echo get_the_post_thumbnail($post_id, 'upcoming_event_sidebar'); ?></a>

          <h2><a href="<?php echo get_permalink($post_id) ?>" title="<?php echo get_the_title($post_id); ?>"> <?php echo get_the_title($post_id); ?></a></h2>
          <h3>Opening</h3>
          <h4>

       <?php
          if (get_post_meta($post_id,'event_venue', true) != 'other') {
              echo get_post_meta($post_id,'event_venue', true);
              }
          if (get_post_meta($post_id,'event_venue', true) == 'other') {
              echo get_post_meta($post_id,'custom_event_venue', true);
              }

       ?>
       </h4>
       <h5><?php $opening_time_formated = date($convertedtime, strtotime( get_post_meta($post_id,'opening_time', true)));
            echo $opening_time_formated;?> </h5>
                <hr />
          </li><!-- end .sidebar_event -->
          <?php }

          else if ($time_key == 'artist_talk_time') { ?>

          <li class="sidebar_event">
          <a href="<?php echo get_permalink($post_id) ?>" title="<?php echo get_the_title($post_id); ?>"> <?php echo get_the_post_thumbnail($post_id, 'upcoming_event_sidebar'); ?></a>

          <h2><a href="<?php echo get_permalink($post_id) ?>" title="<?php echo get_the_title($post_id); ?>"> <?php echo get_the_title($post_id); ?></a></h2>
          <h3>Artist Talk</h3>
          <h4><?php echo get_post_meta($post_id,'event_venue', true);?> </h4>
          <h5><?php $artist_talk_time_formated = date($convertedtime, strtotime( get_post_meta($post_id,'artist_talk_time', true)));
            echo $artist_talk_time_formated;?>  </h5>
          <hr />
          </li><!-- end .sidebar_event -->
          <?php }

           else if ($time_key == 'closing_time') { ?>
           <li class="sidebar_event">
           <a href="<?php echo get_permalink($post_id) ?>" title="<?php echo get_the_title($post_id); ?>"> <?php echo get_the_post_thumbnail($post_id, 'upcoming_event_sidebar'); ?></a>

          <h2><a href="<?php echo get_permalink($post_id) ?>" title="<?php echo get_the_title($post_id); ?>"> <?php echo get_the_title($post_id); ?></a></h2>
          <h3>Closing</h3>
          <h4><?php echo get_post_meta($post_id,'event_venue', true);?> </h4>
          <h5><?php echo get_post_meta($post_id,'closing_time', true);?> </h5>
          <hr />
          </li><!-- end .sidebar_event -->
          <?php }

           else if ($time_key == 'special_event_time') { ?>
           <li class="sidebar_event">
           <a href="<?php echo get_permalink($post_id) ?>" title="<?php echo get_the_title($post_id); ?>"> <?php echo get_the_post_thumbnail($post_id, 'upcoming_event_sidebar'); ?></a>

          <h2><a href="<?php echo get_permalink($post_id) ?>" title="<?php echo get_the_title($post_id); ?>"> <?php echo get_the_title($post_id); ?></a></h2>
          <h3>Special Event</h3>
          <h4><?php echo get_post_meta($post_id,'event_venue', true);?> </h4>
          <h5><?php $special_event_time_formated = date($convertedtime, strtotime( get_post_meta($post_id,'special_event_time', true)));
            echo $special_event_time_formated;?></h5>
          <hr />
          </li><!-- end .sidebar_event -->
          <?php }

           }

            rewind_posts();
      ?>

      </ul>

      <?php
       }
       ?>
       <br />
      <br />
      </div>

      </div><!-- end .sidebar_upcoming_events-->