# pg_exec ($dbh, "SET DateStyle = 'ISO'") or die("Datenbank-Abfrage!");
- $query = "SELECT name,person.oid,email FROM person,junction "
+ $query = "SELECT name,person.oid,email,comment FROM person,junction "
."WHERE person = name AND junction.project = 'Supporter' ORDER BY name";
$sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
if (strlen ($row['email'])) {
$name .= " <" . $row['email'] . ">";
}
+ if (strlen ($row['comment']) && ereg ("(\+[0-9]+ [0-9]+ [0-9]+)", $row['comment'], $phone)) {
+ $name .= " (" . $phone[1] .")";
+ }
+
printf ($t_row, $color, $name);
}
$color=$color == "<cold>"?"<coln>" : "<cold>";