multidimensional array - how to create a new column from php foreach -

i have group of classes on monday , take place in 5 different rooms. i'd present them in columns based on location using divs , sort location, start. data no problem (find classes run on monday) lists in 1 column foreach arrays incorrect. here's $data

$calendar = array(); foreach ($data $row) {     $calendar[$row[0]][] = $row; } foreach($calendar $key => $row) {        foreach($row $field => $value) {             $recnew[$field][] = $value;        } } 

here's array exerpt

    array(1) {      [""]=> array(20)       {      [0]=> array(1) {      ["calendars"]=> array(9) {      ["id"]=> string(3) "742"       ["title"]=> string(4) "yoga"       ["start_date"]=> string(10) "2015-09-14"       ["end_date"]=> string(10) "0000-00-00"       ["start_time"]=> string(8) "20:00:00"       ["end_time"]=> string(8) "21:00:00"       ["location"]=> string(8) "studio 1"       ["calendar_category_id"]=> string(1) "3"       ["recur_mon"]=> string(1) "1"        }       }      [1]=> array(1) {       ["calendars"]=> array(9) {       ["id"]=> string(3) "743"       ["title"]=> string(2) "gx"       ["start_date"]=> string(10) "2015-09-14"       ["end_date"]=> string(10) "0000-00-00"       ["start_time"]=> string(8) "18:00:00"       ["end_time"]=> string(8) "18:45:00"       ["location"]=> string(8) "studio 1"       ["calendar_category_id"]=> string(1) "3"       ["recur_mon"]=> string(1) "1"      } }      [2]=> array(1) {      ["calendars"]=> array(9) {      ["id"]=> string(3) "447"      ["title"]=> string(4) "spin"       ["start_date"]=> string(10) "2015-09-14"      ["end_date"]=> string(10) "0000-00-00"      ["start_time"]=> string(8) "09:15:00"      ["end_time"]=> string(8) "10:00:00"      ["location"]=> string(8) "studio 1"      ["calendar_category_id"]=> string(1) "3"      ["recur_mon"]=> string(1) "1"       } }       [3]=> array(1) {      ["calendars"]=> array(22) {      ["id"]=> string(3) "448"      ["title"]=> string(4) "spin"      ["start_date"]=> string(10) "2015-09-14"      ["end_date"]=> string(10) "0000-00-00"      ["start_time"]=> string(8) "12:15:00"      ["end_time"]=> string(8) "13:00:00"      ["location"]=> string(8) "studio 1"      ["calendar_category_id"]=> string(1) "3"      ["recur_mon"]=> string(1) "1"  } }       [4]=> array(1) {      ["calendars"]=> array(22) {      ["id"]=> string(3) "684"      ["title"]=> string(4) "spin"      ["start_date"]=> string(10) "2015-09-14"      ["end_date"]=> string(10) "0000-00-00"      ["start_time"]=> string(8) "16:30:00"      ["end_time"]=> string(8) "17:15:00"      ["location"]=> string(8) "studio 1"      ["calendar_category_id"]=> string(1) "3"      ["recur_mon"]=> string(1) "1"      } }       [5]=> array(1) {      ["calendars"]=> array(22) {      ["id"]=> string(3) "545"      ["title"]=> string(4) "yoga"      ["start_date"]=> string(10) "2015-09-14"      ["end_date"]=> string(10) "0000-00-00"      ["start_time"]=> string(8) "18:15:00"      ["end_time"]=> string(8) "19:00:00"      ["location"]=> string(8) "studio 1"      ["calendar_category_id"]=> string(1) "3"      ["recur_mon"]=> string(1) "1"     } }   [6]=> array(1) { ["calendars"]=> array(9) {      ["id"]=> string(3) "549"      ["title"]=> string(4) "yoga"      ["start_date"]=> string(10) "2015-09-14"      ["end_date"]=> string(10) "0000-00-00"      ["start_time"]=> string(8) "09:00:00"      ["end_time"]=> string(8) "10:00:00"      ["location"]=> string(8) "studio 2"      ["calendar_category_id"]=> string(1) "3"      ["recur_mon"]=> string(1) "1"  } }       [7]=> array(1) { ["calendars"]=> array(9) {      ["id"]=> string(3) "688"      ["title"]=> string(7) "weights"     ["start_date"]=> string(10) "2015-09-14"      ["end_date"]=> string(10) "0000-00-00"      ["start_time"]=> string(8) "10:10:00"      ["end_time"]=> string(8) "11:00:00"      ["location"]=> string(8) "studio 2"      ["calendar_category_id"]=> string(1) "3"      ["recur_mon"]=> string(1) "1"     } }       [8]=> array(1) { ["calendars"]=> array(9) {      ["id"]=> string(3) "572"      ["title"]=> string(4) "yoga"      ["start_date"]=> string(10) "2015-09-14"      ["end_date"]=> string(10) "0000-00-00"      ["start_time"]=> string(8) "12:10:00"      ["end_time"]=> string(8) "13:10:00"      ["location"]=> string(8) "studio 2"      ["calendar_category_id"]=> string(1) "3"      ["recur_mon"]=> string(1) "1"       } }       [9]=> array(1) { ["calendars"]=> array(9) {      ["id"]=> string(3) "548"      ["title"]=> string(4) "spin"      ["start_date"]=> string(10) "2015-09-14"      ["end_date"]=> string(10) "0000-00-00"      ["start_time"]=> string(8) "16:00:00"      ["end_time"]=> string(8) "16:55:00"      ["location"]=> string(8) "studio 2"      ["calendar_category_id"]=> string(1) "3"      ["recur_mon"]=> string(1) "1"      } }       [10]=> array(1) { ["calendars"]=> array(9) {      ["id"]=> string(3) "573"      ["title"]=> string(11) "power yoga"     ["start_date"]=> string(10) "2015-09-14"      ["end_date"]=> string(10) "0000-00-00"      ["start_time"]=> string(8) "18:45:00"      ["end_time"]=> string(8) "19:45:00"      ["location"]=> string(8) "studio 2"      ["calendar_category_id"]=> string(1) "3"      ["recur_mon"]=> string(1) "1"      } }       [11]=> array(1) { ["calendars"]=> array(9) {      ["id"]=> string(3) "742"      ["title"]=> string(4) "yoga"      ["start_date"]=> string(10) "2015-09-14"      ["end_date"]=> string(10) "0000-00-00"      ["start_time"]=> string(8) "20:00:00"      ["end_time"]=> string(8) "21:00:00"      ["location"]=> string(8) "studio 2"      ["calendar_category_id"]=> string(1) "3"      ["recur_mon"]=> string(1) "1"     } }       [12]=> array(1) { ["calendars"]=> array(9) {      ["id"]=> string(3) "552"      ["title"]=> string(5) "zumba"      ["start_date"]=> string(10) "2015-09-14"      ["end_date"]=> string(10) "0000-00-00"      ["start_time"]=> string(8) "10:15:00"      ["end_time"]=> string(8) "11:15:00"      ["location"]=> string(8) "studio 3"      ["calendar_category_id"]=> string(1) "3"      ["recur_mon"]=> string(1) "1"     } }       [13]=> array(1) { ["calendars"]=> array(9) {      ["id"]=> string(3) "622"      ["title"]=> string(4) "yoga"     ["start_date"]=> string(10) "2015-09-14"      ["end_date"]=> string(10) "0000-00-00"      ["start_time"]=> string(8) "11:30:00"      ["end_time"]=> string(8) "12:00:00"      ["location"]=> string(8) "studio 3"      ["calendar_category_id"]=> string(1) "3"      ["recur_mon"]=> string(1) "1"     } }       [14]=> array(1) { ["calendars"]=> array(9) {      ["id"]=> string(3) "570"      ["title"]=> string(22) "body pump (doriana p.)"      ["start_date"]=> string(10) "2015-09-14"      ["end_date"]=> string(10) "0000-00-00"      ["start_time"]=> string(8) "12:15:00"      ["end_time"]=> string(8) "13:15:00"      ["location"]=> string(8) "studio 3"      ["calendar_category_id"]=> string(1) "3"      ["recur_mon"]=> string(1) "1"      } }       [15]=> array(1) { ["calendars"]=> array(9) {      ["id"]=> string(3) "740"      ["title"]=> string(4) "spin"      ["start_date"]=> string(10) "2015-09-14"      ["end_date"]=> string(10) "0000-00-00"      ["start_time"]=> string(8) "13:30:00"      ["end_time"]=> string(8) "14:00:00"      ["location"]=> string(8) "studio 4"      ["calendar_category_id"]=> string(1) "3"      ["recur_mon"]=> string(1) "1     } }       [16]=> array(1) { ["calendars"]=> array(9) {      ["id"]=> string(3) "623"      ["title"]=> string(7) "weights"      ["start_date"]=> string(10) "2015-09-14"      ["end_date"]=> string(10) "0000-00-00"      ["start_time"]=> string(8) "16:45:00"      ["end_time"]=> string(8) "17:45:00"      ["location"]=> string(8) "studio 4"      ["calendar_category_id"]=> string(1) "3"      ["recur_mon"]=> string(1) "1"     } }       [17]=> array(1) { ["calendars"]=> array(9) {      ["id"]=> string(3) "586"      ["title"]=> string(2) "gx"      ["start_date"]=> string(10) "2015-09-14"      ["end_date"]=> string(10) "0000-00-00"      ["start_time"]=> string(8) "18:00:00"      ["end_time"]=> string(8) "18:30:00"      ["location"]=> string(8) "studio 5"      ["calendar_category_id"]=> string(1) "3"      ["recur_mon"]=> string(1) "1"     } }       [18]=> array(1) { ["calendars"]=> array(9) {      ["id"]=> string(3) "613"      ["title"]=> string(7) "weights"     ["start_date"]=> string(10) "2015-09-14"      ["end_date"]=> string(10) "0000-00-00"      ["start_time"]=> string(8) "18:45:00"      ["end_time"]=> string(8) "19:30:00"      ["location"]=> string(8) "studio 5"      ["calendar_category_id"]=> string(1) "3"      ["recur_mon"]=> string(1) "1"     } }       [19]=> array(1) { ["calendars"]=> array(9) {      ["id"]=> string(3) "621"      ["title"]=> string(5) "zumba"      ["start_date"]=> string(10) "2015-09-14"      ["end_date"]=> string(10) "0000-00-00"      ["start_time"]=> string(8) "19:45:00"      ["end_time"]=> string(8) "20:45:00"      ["location"]=> string(8) "studio 5"      ["calendar_category_id"]=> string(1) "3"      ["recur_mon"]=> string(1) "1" } }      }   

    <?php foreach ($recnew $key => $classes) { ?>     <div class="locations-wrapper">         <div class="my-locations"><?php echo $location[$key]; ?></div>         <?php foreach ($classes $class) : ?>         <!-- class info here -->         <div class="class">             <h4><?php echo $class['calendars']['title']; ?></h4>         </div><!-- end div class -->         <?php endforeach; ?>     </div>     <?php } ?> 

this

might need locations key work.

you can try using html table printing result:

<?php  $calendar = array(); foreach ($data $row)  {     for($i=0;$i<count($row);$i++)     {   if(!array_key_exists($row[$i]["calendars"]["location"], $calendar))                  $calendar[$row[$i]["calendars"]["location"]] = array();         array_push($calendar[$row[$i]["calendars"]["location"]], $row[$i]["calendars"]);     } } ?> <table> <tr> <?php foreach($calendar $key => $row): ?> <td>  <table> <tr><td><?php echo $key;?></td></tr> <?php  foreach($row $r): ?> <tr><td><?php echo $r["title"]; ?></td></tr> <?php endforeach;?> </table> </td> <?php endforeach;?> </tr> </table>