VEDENÍ ŠKOLY
| Titul | Příjmení a jméno | Funkce | Vyučuje | E-mail |
0 ORDER BY func, surname");
while ($record=mysql_fetch_array($result)):
echo "\n";
echo "| ", $record['prefix'], " | \n";
echo '', $record['surname'], ' ', $record['name'], $record['postfix']?', '.$record['postfix']:'', " | \n";
echo "", $record['func']==1 ? 'ředitel školy' : 'zástupce ředitele', " | \n";
echo "";
$ares=dgQuery("SELECT shortd, longd FROM qualification, t2q WHERE t2q.teacher=".$record['id']." AND qualification.id=t2q.qualification ORDER BY tab");
$str='';
while($arec=mysql_fetch_row($ares)) $str[]=''.$arec[0].'';
$str=Implode($str, ', ');
echo $str;
echo " | \n";
echo '', $record['mail'], " | \n";
echo " \n";
endwhile;
?>
UČITELÉ
| Titul | Příjmení a jméno | Vyučuje | E-mail |
\n";
echo "", $record['prefix'], " | \n";
echo '', $record['surname'], ' ', $record['name'], $record['postfix']?', '.$record['postfix']:'', " | \n";
echo "";
$ares=dgQuery("SELECT shortd, longd FROM qualification, t2q WHERE t2q.teacher=".$record['id']." AND qualification.id=t2q.qualification ORDER BY tab");
$str='';
while($arec=mysql_fetch_row($ares)) $str[]=$arec[0]=='0'?$arec[1]:''.$arec[0].'';
$str=Implode($str, ', ');
echo $str;
echo " | \n";
echo '', $record['mail'], " | \n";
echo "\n";
Next($result);
endwhile;
?>
ZAMĚSTNANCI
|
