//Select Maitre
$sqlAlias[0]="selectEntrainement";
$sqlQuerys[0]="SELECT (
    SELECT COUNT(*)
    FROM presence
    WHERE presence.Date = entrainement.Datesoir
  ) AS Nb,
case dayname(Datesoir)
  when 'Tuesday'  then 'Mardi'
  when 'Friday'   then 'Vendredi'
  when 'Saturday' then 'Samedi'
  when 'Sunday'   then 'Dimanche'
  when 'Monday'   then 'Lundi'
  when 'Wednesday' then 'Mercredi'
  when 'Thursday' then 'Jeudi'
  end AS Jour,
Datesoir,
Observation
FROM entrainement
WHERE (Datesoir between date_add(current_date,INTERVAL -6 DAY) and date_add(current_date,INTERVAL +6 DAY)) ORDER BY Datesoir DESC";
$sqlMaxUserLevel[0]=-1;

//Select Detail
$sqlAlias[1]="selectPresence";
$sqlQuerys[1]="select Date, Nom, heure from presence where Date = ?";
$sqlMaxUserLevel[1]=-1;

//Select Joueur
$sqlAlias[2]="selectJoueur";
$sqlQuerys[2]="select NOM from joueur where ACTIF = 1";
$sqlMaxUserLevel[2]=-1;

//Insert présence
$sqlAlias[3]="insertPresence";
$sqlQuerys[3]="insert into presence values (?,?,?)";
$sqlMaxUserLevel[3]=-1;

//Delete présence
$sqlAlias[4]="deletePresence";
$sqlQuerys[4]="delete from presence where Date = ? and Nom = ?";
$sqlMaxUserLevel[4]=-1;
