I’m working on a TV series web site.
On the series infos page, is a link directing to the episode list.

I would to display the episodes in a table, grouping them by season, separating each season by a border.

I tried to group the query results in my SQL query, but, the code displays a border under each episode.

Could someone help, please ?

I tried this :

<?php
    $titles = getTitle();
    $episodeList = getEpisodes();
    $seriesIdTest = getPageOnError();
    
    if((isset($_GET['series'])) && ($_GET['series'] > 0) && ($_GET['series'] == $seriesIdTest)) { // If string is not empty then first test if string match the selection
        $seriesIdTest = $_GET['series'];
    } else { // If the test fails, return to greating page
        header("Location: accueil.php");
        ob_clean();
        die();
    }
?>  
<section class="series accueilContainer episodeSection col-10">
    <article class="seriesRecord">
    
        <!-- TITLE DISPLAY -->
        <h1 class="episodesTitle epListTitle"><mark>EPISODES</mark></h1>
        <h1 class="episodesTitle epListTitle"><mark><?php echo $titles['title']; ?><mark></h1>
        
        <!-- EPISODES SECTION DISPLAY -->
        
        <table class="episodeTable">
            <?php
                foreach ($episodeList as $episodes) { ?>
                    <tr class="seasonLine">
                        <tr>
                            <td class="episodeCell episodeNumberCell"><span class="episodes"><?php echo $episodes['epNumber']; ?></span></td>
                            <td class="episodeCell episodeSeasonCell"><span class="episodes"><?php echo $episodes['seasonNumber']."-".$episodes['seasonEpNumber']; ?></span></td>
                            <td class="episodeCell episodeOrigCell"><span class="episodes"><?php echo $episodes['episodeTitle']; ?></span></td>
                            <td class="episodeCell episodeFrenchCell"><span class="episodes"><?php echo $episodes['frenchEpisodeTitle']; ?></span></td>
                        </tr>
                    </tr>
            <?php } ?>
                </table>
    </article>
</section>