<?php

$userAssocArray = $sql->assoc_array("
    SELECT
        uk_name AS 'Név',
        CASE 
            WHEN uk_gender = 1 THEN 'fiú'
            ELSE 'lány'
        END AS 'Nem',
        uk_birth_date AS 'Születési dátum',        
        scc_city AS 'Lakhely',
        CASE 
            WHEN uk_hand = 1 THEN 'bal'
            ELSE 'jobb'
        END AS 'Kéz',
        sc_name AS 'Iskola',
        uk_email AS 'Email',
        uk_phone AS 'Telefonszám',
        p1.up_name AS 'Szülő',
        p1.up_email AS 'Szülő Email',
        p1.up_phone AS 'Szülő Telefonszám',
        uk_other AS 'Egyéb'
    FROM
        user_kid
            LEFT JOIN
        user_parent p1 ON p1.up_id = uk_parent_1
            LEFT JOIN
        school ON sc_id = uk_school_sc_id
            LEFT JOIN
        user_kid_training_type ON uktt_user_kid_uk_id = uk_id
            LEFT JOIN
        school_city ON uk_address_scc_id = scc_id
    WHERE
        uk_deleted = 0 AND uk_is_active = 1
    GROUP BY uk_name
    ORDER BY uk_name;
");

$filename = "taglista.csv";
$fp = fopen('php://output', 'w');

fputcsv($fp, array_keys(reset($userAssocArray)), ';');
ob_end_clean();

header('Content-type: application/csv');
header('Content-Disposition: attachment; filename='.$filename);

foreach($userAssocArray as $row) {
    fputcsv($fp, $row, ';');
}
exit(1);