Clubrecords Pupillen Jongens

Outdoor

[insert_php]

setlocale(LC_ALL,’nl_NL’);
global $wpdb;

$cat = ‘PUPJ’;
$arr = array(1,6,2,0,18);
foreach ($arr as &$proef) {

$query = $wpdb->get_results(“select voornaam,naam,date_format(pres_dat,’%d-%m-%Y’) datum,proef,locatie,tijd from atleet_prestaties where categorie= ‘” . $cat . “‘ and proef_id = ” . $proef . ” and indoor=0 order by tijd2 asc limit 1 “);

foreach ($query as $row) {
echo “

“;
}
}
$arr = array(13,14,16,17);
foreach ($arr as &$proef) {

$query = $wpdb->get_results(“select voornaam,naam,date_format(pres_dat,’%d-%m-%Y’) datum,proef,locatie,afstand from atleet_prestaties where categorie= ‘” . $cat . “‘ and proef_id = ” . $proef . ” and indoor=0 order by afstand desc limit 1 “);

foreach ($query as $row) {
echo “

“;
}
}

$arr = array();
foreach ($arr as &$proef) {

$query = $wpdb->get_results(“select voornaam,naam,date_format(pres_dat,’%d-%m-%Y’) datum,proef,locatie,punten from atleet_prestaties where categorie= ‘” . $cat . “‘ and proef_id = ” . $proef . ” and indoor=0 order by afstand desc limit 1 “);

foreach ($query as $row) {
echo “

“;
}
}

[/insert_php]

Indoor

[insert_php]

setlocale(LC_ALL,’nl_NL’);
global $wpdb;

$cat = ‘PUPJ’;
$arr = array(1,2,0,18);
foreach ($arr as &$proef) {

$query = $wpdb->get_results(“select voornaam,naam,date_format(pres_dat,’%d-%m-%Y’) datum,proef,locatie,tijd from atleet_prestaties where categorie= ‘” . $cat . “‘ and proef_id = ” . $proef . ” and indoor=1 order by tijd2 asc limit 1 “);

foreach ($query as $row) {
echo “

“;
}
}
$arr = array(12,13,14,15,16);
foreach ($arr as &$proef) {

$query = $wpdb->get_results(“select voornaam,naam,date_format(pres_dat,’%d-%m-%Y’) datum,proef,locatie,afstand from atleet_prestaties where categorie= ‘” . $cat . “‘ and proef_id = ” . $proef . ” and indoor=1 order by afstand desc limit 1 “);

foreach ($query as $row) {
echo “

“;
}
}

$arr = array(28);
foreach ($arr as &$proef) {

$query = $wpdb->get_results(“select voornaam,naam,date_format(pres_dat,’%d-%m-%Y’) datum,proef,locatie,punten from atleet_prestaties where categorie= ‘” . $cat . “‘ and proef_id = ” . $proef . ” and indoor=1 order by afstand desc limit 1 “);

foreach ($query as $row) {
echo “

“;
}
}
[/insert_php]