prepare("SELECT id, class FROM 2w_race_manager_classes");
$sth->execute();
while ($o = $sth->fetchObject()) {
$klases[$o->id] = $o->class;
}
// dalibnieki
$dalibnieki = [];
$sth = $dbh->prepare("SELECT id, class_id, team_id, team_name, email, phone, country, rider, rider_licence_nr, rider_moto,
rider_moto_weight, rider_moto_displacement, rider_moto_plate_nr, rider_tshirt, rider_consent, rider_paid, status
FROM 2w_race_manager_signup
WHERE status = 0
ORDER BY class_id, team_id, id");
$sth->execute();
while ($o = $sth->fetchObject()) {
$dalibnieki[$o->id] = $o;
}
$header = "";
?>
Dalībnieki un komandas
$d) {
if ($d->class_id != $class_id) {
echo "| {$klases[$d->class_id]} |
| Komandas ID | Komandas Nosaukums | Braucējs | Mocis |
";
}
$class_id = $d->class_id;
echo "
| $d->team_id |
$d->team_name |
$d->rider |
$d->rider_moto |
";
}
?>