D’Minibléiser

D’Minibléiser

”) “;
$strSQL .= “order by dtInstrument”;
$rstInstruments = $wpdb->get_results( $strSQL, ARRAY_A );
//
// members with this instrument
//
echo “

“;
foreach($rstInstruments as $inInstruments) :
$strInstrumentLib = $inInstruments[‘dtInstrument’].” (“.$inInstruments[‘countMem’].”)”;
$strInstrumentTag = $inInstruments[‘dtInstrument’];
$strInstrumentTag = str_replace(” “, “_”, $strInstrumentTag);
$strInstrumentTag = “ù”.$strInstrumentTag;
echo “
• “;
  echo ““.$strInstrumentLib.”“;
  echo “

“;
$strSQL = “SELECT dtNom, dtPrenom FROM tabMembres WHERE $memXXX = ‘”.$inInstruments[‘dtInstrument’].”‘ order BY dtNom, dtPrenom”;
$rstInstrumentMembres = $wpdb->get_results( $strSQL, ARRAY_A );
foreach($rstInstrumentMembres as $inInstrumentMembres) :
$i = $i + 1;
//echo “

• “;
  echo “
  “.”- “.$inInstrumentMembres[‘dtNom’].” “.$inInstrumentMembres[‘dtPrenom’].”

  “;
  //echo “

“;
endforeach;
endforeach;
echo “

“;
//
// number of members + datum stand
//
$strSQL = “select date_format(max(dtUpdate),’%d/%m/%Y’) as dtUpdate from tabMembres”;
$inInstruments = $wpdb->get_row( $strSQL, ARRAY_A, 0 );
echo $i.” Musikanten (Stand: “.$inInstruments[‘dtUpdate’].”)”;
echo “

“;
?>