#include <lt2001.style>

<page title="Insurance" subtitle=Insurance>

<?
  $t_head  = "<p><div align=\"center\"><table width=\"99%\" cellpadding=\"0\" cellspacing=\"0\" summary=\"\">";
  $t_title = "<tr bgcolor=\"%s\"><th><font face=\"Helvetica,Arial\">Name</font></th><th><font face=\"Helvetica,Arial\">Project</font></th></tr>";
  $t_row   = "<tr bgcolor=\"%s\"><td><font face=\"Helvetica,Arial\">%s</font></td><td><font face=\"Helvetica,Arial\">%s</font></td></tr>";
  $t_sum   = "<tr bgcolor=\"%s\"><td colspan=\"2\"><b><font face=\"Helvetica,Arial\">%d Personen</font></b></td></tr>";
  $t_foot  = "</table></div><p>";

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

  # pg_exec ($dbh, "SET DateStyle = 'ISO'") or die("Datenbank-Abfrage!");

  $query = "SELECT name,email,project,oid FROM person WHERE insurance = 1 AND list = 0 ORDER BY name";
  $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");

  if (pg_NumRows ($sth) > 0) {
    echo ($t_head);
    printf ($t_title, "<colh>");

    $color = "<cold>";
    $count = 0;
    for ($nr=0; $nr < pg_NumRows ($sth); $nr++) {
      $count++;
      $color=$color == "<cold>"?"<coln>" : "<cold>";
      $row = pg_fetch_array ($sth, $nr);
      if (strlen ($row['email'])) {
        $name = sprintf ("<a href=\"edit_person.php3?oid=%d\">%s</a> &lt;%s&gt;", $row['oid'], $row['name'], $row['email']);
      } else {
        $name = sprintf ("<a href=\"edit_person.php3?oid=%d\">%s</a>", $row['oid'], $row['name']);
      }
      printf ($t_row, $color, $name, $row['project']);
    }
    $color=$color == "<cold>"?"<coln>" : "<cold>";
    printf ($t_sum, $color, $count);
    echo ($t_foot);
  }
?>

</table>

</page>

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