Trier un tableau php dynamiquement

Bonjour,

j'affiche dans une page des clients rentrés dans ma BDD par ordre de date de . 

Je souhaiterai pouvoir mettre un lien sur les entête de mon tableau, afin que l'utilisateur, puisse trier par la colonne qu'il veut.

mon affichage : 

<table class="table table-striped">
      <thead>
            <tr>
                  <th>ID</th>
                  <th>NOM</th>
                  <th>PRENOM</th>
                  <th>DATE</th>
                  <th>ACTIVITE</th>
                  <th>SOCIETE</th>
                  <th>EMAIL</th>
                  <th></th>
                  <th>DEPARTEMENT</th>
                  <th>TELEPHONE</th>
                  <th>MESSAGE</th>
            </tr>
      </thead>
      <tbody>
            <?php foreach ($orders as $order) : ?>
                  <tr>
                        <td><?= $order["ID"] ?></td>
                        <td><?= $order["Nom"] ?></td>
                        <td><?= $order["Prénom"] ?></td>
                        <td><?= $order["dateinscription"] ?></td>
                        <td><?= $order["Travaux"] ?></td>
                        <td><?= $order["Provenance"] ?></td>
                        <td><?= $order["Email"] ?></td>
                        <td><?= $order["CodePostal"] ?></td>
                        <td><?= $order["Departement"] ?></td>
                        <td><?= $order["Téléphone"] ?></td>
                        <td><?= substr($order["Message"] ,0, 250)?></td>
                  </tr>
            <?php endforeach ?>
      </tbody>
</table>

mon code de requête d'affichage : 

<?php
error_reporting(E_ALL);
ini_set('display_errors', TRUE);
ini_set('display_startup_errors', TRUE);

error_reporting(-1);
require 'fonctionsovh-2024.php';
$db = getConnection();

$query = $db->prepare("
SELECT ID, Nom, Prénom, dateinscription, Travaux, Provenance, Email, CodePostal, Departement, Téléphone, Message
FROM `2024` 
ORDER BY dateinscription
");

$query->execute();

$orders = $query->fetchAll();


$reponse = $db->prepare("
SELECT COUNT(*) AS nbClients 
FROM `2024` 
");
$reponse->execute();
$donnees1 = $reponse->fetch();

$reponsea = $db->prepare("
SELECT COUNT(*) AS janvier 
FROM `2024` 
WHERE (dateinscription BETWEEN '2024-01-01' AND '2024-02-01')
");
$reponsea->execute();
$donnees2 = $reponsea->fetch();

$reponseb = $db->prepare("
SELECT COUNT(*) AS fevrier 
FROM `2024` 
WHERE (dateinscription BETWEEN '2024-02-01' AND '2024-03-01')
");
$reponseb->execute();
$donnees3 = $reponseb->fetch();

$reponsec = $db->prepare("
SELECT COUNT(*) AS mars 
FROM `2024` 
WHERE (dateinscription BETWEEN '2024-03-01' AND '2024-04-01')
");
$reponsec->execute();
$donnees4 = $reponsec->fetch();

$reponsed = $db->prepare("
SELECT COUNT(*) AS avril 
FROM `2024` 
WHERE (dateinscription BETWEEN '2024-04-01' AND '2024-05-01')
");
$reponsed->execute();
$donnees5 = $reponsed->fetch();

$reponsee = $db->prepare("
SELECT COUNT(*) AS mai 
FROM `2024` 
WHERE (dateinscription BETWEEN '2024-05-01' AND '2024-06-01')
");
$reponsee->execute();
$donnees6 = $reponsee->fetch();

$reponsef = $db->prepare("
SELECT COUNT(*) AS juin 
FROM `2024` 
WHERE (dateinscription BETWEEN '2024-06-01' AND '2024-07-01')
");
$reponsef->execute();
$donnees7 = $reponsef->fetch();

$reponseg = $db->prepare("
SELECT COUNT(*) AS juillet 
FROM `2024` 
WHERE (dateinscription BETWEEN '2024-07-01' AND '2024-08-01')
");
$reponseg->execute();
$donnees8 = $reponseg->fetch();

$reponseh = $db->prepare("
SELECT COUNT(*) AS aout 
FROM `2024` 
WHERE (dateinscription BETWEEN '2024-08-01' AND '2024-09-01')
");
$reponseh->execute();
$donnees9 = $reponseh->fetch();

$reponsei = $db->prepare("
SELECT COUNT(*) AS septembre 
FROM `2024` 
WHERE (dateinscription BETWEEN '2024-09-01' AND '2024-10-01')
");
$reponsei->execute();
$donnees10 = $reponsei->fetch();

$reponsej = $db->prepare("
SELECT COUNT(*) AS octobre 
FROM `2024` 
WHERE (dateinscription BETWEEN '2024-10-01' AND '2024-11-01')
");
$reponsej->execute();
$donnees11 = $reponsej->fetch();

$reponsek = $db->prepare("
SELECT COUNT(*) AS novembre 
FROM `2024` 
WHERE (dateinscription BETWEEN '2024-11-01' AND '2024-12-01')
");
$reponsek->execute();
$donnees12 = $reponsek->fetch();

$reponsel = $db->prepare("
SELECT COUNT(*) AS decembre 
FROM `2024` 
WHERE (dateinscription BETWEEN '2024-12-01' AND '2025-01-01')
");
$reponsel->execute();
$donnees13 = $reponsel->fetch();

?>

les requetes reponsea .... sont pour l'affichage dans un autre tableau du nombre de s par mois .

Pourriez vous me dire comment trier sur la colonne travaux par ex?

merci d'avance.

J
Windows / Chrome 120.0.0.0