Export en csv

<?php
if (isset($_REQUEST["aid"]))

{
    require_once("../connexion.php");

    $output = fopen('php://output', 'w');
    fputcsv($output, array('Agence', 'adresse, 'Nom', 'Prenom', 'Date'), ";");
   
    
    $query = "SELECT nom_agence,adresse,nom,prenom,date FROM client c LEFT JOIN agence a ON c.idagence = a.idagence
    
   
    $result = mysql_query($query) or die(mysql_error());
    
    
    header('Content-Type: text/csv; charset=utf-8');
    header('Content-Disposition: attachment; filename=liste-clients-agence-'.date('d-m-Y-H-i-s').'.csv');

    while ($row = mysql_fetch_assoc($result))
    {
       
        fputcsv($output, $row, ";");
    }
    fclose($output);
    
}

?>