?>
<p class="list-text">
<?php
if (mysqli_num_rows($courses) > 0) {
?>
<?php
while ($course = mysqli_fetch_array($courses)) {
?>
<?php
$q = MYSQLI_QUERY($link, "Select * From `location` where id=" . $course['locationID']);
$location = $q ? mysqli_fetch_array($q) : null;
$date = $course['datum_von'] != $course['datum_bis'] ? date_mysql2german($course['datum_von'], "%02d.%02d.") . ' - ' . date_mysql2german($course['datum_bis']) : date_mysql2german($course['datum_von']);
?>
<?php
echo $date;
echo $location ? ', ' . getTranslationValue($location['name'], $lang) : '';
?>
<br/>
<?php
}
?>
<?php
} else {
?>
<?php
echo t('course.date.will_be_anounced');
?>
<?php
}
?>
</p>
}
?>
<?php
while ($courseTypeM = mysqli_fetch_array($l_courses_advanced)) {
?>
<li class="noline"><a href="kurs_detail.php?lang=<?php
echo $lang;
?>
&kategorie=<?php
echo $courseTypeM['id'];
?>
" class="<?php
echo $nav_a_class;
?>
"><?php
echo nl2br(trim(getTranslationValue($courseTypeM['title'], $lang)));
?>
</a></li>
<?php
}
?>
<li class="noline"><a href="pruefungen.php?lang=<?php
echo $lang;
?>
" class="<?php
echo $nav_a_class;
?>
"><?php
echo t('menu.main.exams');
?>
</a></li>
</div>
<ul>
<?php
while ($daten2 = mysqli_fetch_array($l_exams)) {
?>
<li <?php
if ($daten2['id'] == $kategorie) {
echo "class='linkhover'";
}
?>
><a href="termine.php?lang=<?php
echo $lang;
?>
&kategorie=<?php
echo $daten2['id'];
?>
"><?php
echo trim(nl2br(getTranslationValue($daten2['title'], $lang)));
?>
</a></li>
<?php
}
?>
</ul>
<?php
include 'inc/certificate_at.php';
?>
<select name="kategorie" style="width:400px;">
<option value="">- <?php
echo $datentrans5[$lang];
?>
-</option>
<?php
foreach ($courseTypeArray as $id => $courseType) {
?>
<option value="<?php
echo $id;
?>
" <?php
echo $kategorie == $id ? 'selected' : '';
?>
><?php
echo getTranslationValue($courseType['title'], $lang);
?>
</option>
<?php
}
?>
</select>
<input type="submit" name="buttonx" id="button" value="<?php
echo $formtran31[$lang];
?>
" />
</form>
<?php
