Trier un tableau php dynamiquement

Bonjour,

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

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>CP</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 `Contact2024` 
ORDER BY dateinscription
");

$query->execute();

$orders = $query->fetchAll();


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

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

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

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

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

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

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

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

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

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

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

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

$reponsel = $db->prepare("
SELECT COUNT(*) AS decembre 
FROM `Contact2024` 
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 contacts par mois .

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

merci d'avance.

J
Windows / Chrome 120.0.0.0