![](\"../images/blank.gif\") |
|
|
|
|
";
$query = "SELECT t1.saaid
, t1.dst_id
, DATE_Format(t1.beginn, '%d.%m.%Y') beginn
, DATE_Format(t1.ende, '%d.%m.%Y') ende
, DATE_FORMAT(t1.beginn, '%Y%m%d') beginnform
, t1.vert_bereich
FROM stan_antrag t1
WHERE t1.status = (
SELECT MAX(t2.status)
FROM stan_antrag t2
WHERE t1.aendid = t2.aendid
)
AND t1.uid = '$uid1'
AND t1.status = '-1'
AND (t1.zuweisung is NULL OR t1.zuweisung='Z')
ORDER BY beginnform ASC
";
$result = $db->query ($query)
or die ("Cannot execute query");
echo"
|
Bezeichnung
|
Vertiefungsbereich
|
Zeitraum
|
";
while ($row3 = $result->fetch_array()){
$result5 = $db->query("SELECT concat(bezeichnung, ' ',name) name, ort
FROM stan_dienststellen
WHERE dst_id ='$row3[dst_id]'");
$row5 = $result5->fetch_array();
$result6 = $db->query("SELECT bez, ort
FROM stan_dienststellen_tmp
WHERE dst_id ='$row3[dst_id]'");
$row6 = $result6->fetch_array();
if($row5[name] != '' and $row6[bez] == ''){
$bezeichnung = $row5[name];
$ort = $row5[ort];
}
if($row5[name] == '' and $row6[bez] != ''){
$bezeichnung = $row6[bez];
$ort = $row6[ort];
}
if($row5[name] == '' and $row6[bez] == ''){
$bezeichnung = '[Daten bitte nachtragen]';
$ort = '';
}
$result1 = $db->query ("SELECT bezeichnung
FROM stan_vertiefungsbereich
WHERE vbid = $row3[vert_bereich]
");
$row_vert = $result1->fetch_array();
echo"
|
$bezeichnung
|
$row_vert[bezeichnung]
|
$row3[beginn] - $row3[ende]
|
";
}
echo"
|
|
|
|
|
|
|
![](\"../images/zurueck.gif\")