#include <ltol.style>

<page func="Oldenburger LinuxTag 2000" title="Personal">

<p>Telefonnummern aus dieser Liste werden <b>nicht</b> weitergegeben.
Das gilt insbesondere für die Nummern der Mobiltelefone.

<h3><font face="Helvetica,Arial">Orga-Team</font></h3>

<table width=100% border=0 cellspacing=0 cellpadding=1 bgcolor=#ffffff>
<tr bgcolor=#<colh>><th width=35% align=left><font face="Helvetica,Arial">Name</font></th><th width=35% align=left><font face="Helvetica,Arial">E-Mail</font></th><th width=15% align=left><font face="Helvetica,Arial">Telefon</font></th><th width=15% align=left><font face="Helvetica,Arial">Mobil</font></th></tr>

<?
  $bgcolor="<cold>";

  $dbh = pg_pconnect ("<dbhost>", "<dbport>", "<dbname>")
	 or die("Unable to connect to SQL server");

  $query = "SELECT name,email,telefon,mobil FROM personal WHERE type = 'Orga' ORDER BY name";
  $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");

  for ($nr=0; $nr < pg_NumRows ($sth); $nr++) {
    $row = pg_fetch_array ($sth, $nr);
    if (!strlen ($row['mobil'])) { $row['mobil'] = "&nbsp;"; }
    if (!strlen ($row['telefon'])) { $row['telefon'] = "&nbsp;"; }
    $bgcolor = $bgcolor == "<cold>"?"<coln>":"<cold>";

    printf ("<tr bgcolor=\"#%s\"><td><font face=\"Helvetica,Arial\">%s</font></td>", $bgcolor, $row['name']);
    printf ("<td><font size=\"-1\" color=\"#%s\">&lt;</font><font size=\"-1\" face=\"Helvetica,Arial\">%s"
	   ."</font><font size=\"-1\" color=\"#%s\">&gt;</font></td>",
      $bgcolor, $row['email'], $bgcolor);
    printf ("<td><font size=\"-1\" face=\"Helvetica,Arial\">%s</font></td>", $row['telefon']);
    printf ("<td><font size=\"-1\" color=\"#%s\"> · </font><font size=\"-1\" face=\"Helvetica,Arial\">%s</font></td></tr>",
      $bgcolor, $row['mobil']);
  }
?>

</table><p>

<h3><font face="Helvetica,Arial">Helfer</font></h3>

<table width=100% border=0 cellspacing=0 cellpadding=1 bgcolor=#ffffff>
<tr bgcolor=#<colh>><th width=35% align=left><font face="Helvetica,Arial">Name</font></th><th width=35% align=left><font face="Helvetica,Arial">E-Mail</font></th><th width=15% align=left><font face="Helvetica,Arial">Telefon</font></th><th width=15% align=left><font face="Helvetica,Arial">Mobil</font></th></tr>

<?
  $bgcolor="<cold>";

  $query = "SELECT name,email,telefon,mobil FROM personal WHERE type = 'Helfer' ORDER BY name";
  $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");

  for ($nr=0; $nr < pg_NumRows ($sth); $nr++) {
    $row = pg_fetch_array ($sth, $nr);
    if (!strlen ($row['mobil'])) { $row['mobil'] = "&nbsp;"; }
    if (!strlen ($row['telefon'])) { $row['telefon'] = "&nbsp;"; }
    $bgcolor = $bgcolor == "<cold>"?"<coln>":"<cold>";

    printf ("<tr bgcolor=\"#%s\"><td><font face=\"Helvetica,Arial\">%s</font></td>", $bgcolor, $row['name']);
    printf ("<td><font size=\"-1\" color=\"%s\">&lt;</font><font size=\"-1\" face=\"Helvetica,Arial\">%s</font>"
	   ."<font size=\"-1\" color=\"%s\">&gt;</font></td>",
      $bgcolor, $row['email'], $bgcolor);
    printf ("<td><font size=\"-1\" face=\"Helvetica,Arial\">%s</font></td>", $row['telefon']);
    printf ("<td><font size=\"-1\" color=\"%s\"> · </font><font size=\"-1\" face=\"Helvetica,Arial\">%s</font></td></tr>",
      $bgcolor, $row['mobil']);
  }
?>

</table>

</page>

# Local variables:
# mode: text
# mode: auto-fill
# mode: iso-accents
# end: