D’Minibléiser

D’Minibléiser

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 “

 

“;
?>

Monnerecher Musek