1 |
<?php |
2 |
require_once( "../inc/mysql.php" ); |
3 |
$id = $_REQUEST["id"]; |
4 |
|
5 |
|
6 |
$sql = " |
7 |
SELECT dato,enhed |
8 |
FROM moedeprotokol |
9 |
WHERE id = '{$id}' |
10 |
"; |
11 |
|
12 |
$rows = query($sql); |
13 |
|
14 |
$dato = $rows[0]->dato; |
15 |
|
16 |
echo "<b>Møde detaljer for d. {$dato} </b><br><br>"; |
17 |
|
18 |
$sql = " |
19 |
SELECT medlem,navn |
20 |
FROM moededeltager |
21 |
WHERE moedeid = {$id} |
22 |
ORDER BY medlem DESC,navn ASC |
23 |
"; |
24 |
|
25 |
$rows = query($sql); |
26 |
|
27 |
echo "<table border='1'>"; |
28 |
echo "<tr><th colspan=2>Medlemmer</th></tr>"; |
29 |
|
30 |
$count = 1; |
31 |
$nyeheader = false; |
32 |
foreach($rows as $row) { |
33 |
|
34 |
if ($row->medlem == 0 && $nyeheader == false) { |
35 |
echo "<tr><th colspan=2>Nye</th></tr>"; |
36 |
$nyeheader = true; |
37 |
} |
38 |
echo "<tr><td>{$count}</td><td>{$row->navn}</td></tr>\n"; |
39 |
|
40 |
|
41 |
$count++; |
42 |
} |
43 |
|
44 |
|
45 |
?> |