|
|
|
$query="select * from Vorstand where Funktion<6 order by Funktion";
$result=mysql_query($query,$link);
if ($result<0):
$err=$phperrmsg;
echo "";
else:
$rows=mysql_numrows($result);
for ($i=0; $i<$rows; $i++) {?>
|
".mysql_result($result,$i,"Name")." ";
echo mysql_result($result,$i,"Firma")." ";
echo mysql_result($result,$i,"Strasse")." ";
echo mysql_result($result,$i,"Ort")?>
|
"; endif;
if ( mysql_result($result,$i,"Fax") ): echo "Fax: ".mysql_result($result,$i,"Fax")." "; endif;
if ( mysql_result($result,$i,"eMail") ): echo "E-mail: ".mysql_result($result,$i,"eMail")." "; endif;
if ( mysql_result($result,$i,"www") ): echo "".mysql_result($result,$i,"www")." "; endif?>
|
|
}
endif?>
Erweiterter Vorstand |
$query="select * from Vorstand where Funktion>5 order by Funktion";
$result=mysql_query($query,$link);
if ($result<0):
$err=$phperrmsg;
echo "";
else:
$rows=mysql_numrows($result);
for ($i=0; $i<$rows; $i++) {
if ($Ausgabe[mysql_result($result,$i,"Funktion")] != "ja"):?>
|
$Ausgabe[mysql_result($result,$i,"Funktion")]="ja";
endif?>
".mysql_result($result,$i,"Name")."";
if ( mysql_result($result,$i,"Leiter")==1 ): echo " (Leiter";
if ( mysql_result($result,$i,"Anrede")==2 ): echo "in"; endif;
echo ")";
endif; echo " ";
echo mysql_result($result,$i,"Firma")." ";
echo mysql_result($result,$i,"Strasse")." ";
echo mysql_result($result,$i,"Ort")?>
|
"; endif;
if ( mysql_result($result,$i,"Fax") ): echo "Fax: ".mysql_result($result,$i,"Fax")." "; endif;
if ( mysql_result($result,$i,"eMail") ): echo "E-mail: ".mysql_result($result,$i,"eMail")." "; endif;
if ( mysql_result($result,$i,"www") ): echo "".mysql_result($result,$i,"www")." "; endif?>
|
|
}
endif?>
|