function get_time_res_access($mid){
    //le nombre d'heure
    //SELECT SUBTIME((SELECT DATE_ADD(`ambr_date`, INTERVAL 1 DAY)),NOW()) FROM `zrd_al_mbr` where `ambr_mid`=7188

    //le nombre de jour
    //SELECT DATEDIFF((SELECT DATE_ADD(`ambr_date`, INTERVAL 1 DAY)),NOW()) FROM `zrd_al_mbr` where `ambr_mid`=7188
    $sql="SELECT DATEDIFF((SELECT DATE_ADD(`ambr_date`, INTERVAL ALL_NOOB_TIME DAY)),NOW()) as day_left ";//le nombre de jour
    $sql.="SELECT SUBTIME((SELECT DATE_ADD(`ambr_date`, INTERVAL ALL_NOOB_TIME DAY)),NOW()) as hour_left ";//le nombre de heure
    $sql.=" FROM ".$_sql->prebdd."al_mbr ";
    $sql.=" WHERE ambr_mod = $mid";

    return $_sql->make_array($sql);
}