<?php
/**
 * Created by PhpStorm.
 * User: stephan
 * Date: 2021-02-14
 * Time: 13:28
 */

function fxGetInfosAffilies($intCom_ID) {
    global  $objDatabase;
    $strWhere="";
    $sqlAffilies = "
        SELECT a.*, c.com_courriel  AS com_courriel
        FROM inscriptions_comptes a
            JOIN inscriptions_comptes c ON a.com_affilie = c.com_id
        WHERE a.com_affilie = " . intval($intCom_ID). $strWhere
    ;
    $infoAffilies = $objDatabase->fxGetResults($sqlAffilies);

    return $infoAffilies;
}