$enhed";
if ($print == 0) {
echo "[Udskriv]
";
}
} else {
$filter = "";
echo "Medlemmer
";
}
$sql = "select fornavn, efternavn, mobil, email, group_concat(enhed) as enhed,group_concat( rolle) as rolle from
stamdata s left join roller r on (s.id = r.medlemsid)
$filter
group by s.id order by fornavn,efternavn";
$rows = query($sql);
echo "";
echo "\n";
echo "| Fornavn | Efternavn | Mobil | Email | ";
if (isset($enhed)) {
echo "Rolle | ";
} else {
echo "Enheder";
}
echo " |
|---|
\n";
echo "\n";
echo "\n";
$i = 0;
foreach($rows as $row) {
echo "| {$row->fornavn} | {$row->efternavn} | {$row->mobil} | {$row->email} | ";
if (isset($enhed)) {
echo "{$row->rolle} | ";
} else {
echo "{$row->enhed} | ";
}
echo "
\n";
$i = ($i+1)%2;
}
echo "\n";
echo "
";
echo "Antal: " . sizeof($rows) . "";
if ($print == 0) {
require("footer.php");
}
?>