Grouping

Hi Ross,

Thanks for your response. I see that while the WHERE clause is no longer part of the code generator it can still be added back as per the older version. Good news!

Looking at it some more, I thought that using the WHERE clause was not the most efficient method because in the event that I added another course then I could need that hardcode that into the template and FTP it to the server, so I used an associative array to group the courses instead and that works much better and is a one-stop shop. For reference, in the event that anyone else is looking for a similar solution, here is what I did:

First create the associative array:

          $ValMeals = array(); 

          foreach ($valentines_dayRecords as $meal) { 
            $ValCourse = $meal['course']; 

            if (!array_key_exists($ValCourse, $ValMeals)) { 
             $ValMeals[$ValCourse] = array(); 
            } 

            $ValMeals[$ValCourse][] = $meal; 
          } 


Then loop through it:

    <?php foreach ($ValMeals as $courses => $meals): ?>
    <h4><?php echo $courses; ?></h4>
    <?php foreach ($meals as $meal): ?> 
      <div class="name-wrap">
          <div class="box">
              <h6 class="box_aside"><?php echo htmlencode($meal['name_of_dish']) ?></h6>
              <span class="box_right"></span>
          </div>
          <p class="brd"><?php echo htmlencode($meal['description']) ?></p>
      </div>
        <?php endforeach ?> 
        <br><br>
      <?php endforeach ?>

The output was the following with one set of code rather than having to repeat the code for each course, if I were using the WHERE clause.

    STARTERS
    Soup of the Day (v)
    Smoked Salmon and Prawn Cocktail
    Ham Hock Terrine, Apple Relish and Toast
    Baked Camembert

    MAIN
    7oz Ribeye Steak
    Baked Chicken Breast
    Roast Monkfish
    Gnocchi

    DESSERT
    Chocolate Pot and Dipping Fruit
    Sticky Toffee Pudding with Vanilla Ice-cream
    Passion Fruit Pannacotta
    Cheeseboard

Best regards

Terry