horsensspejder-web/ajax/moedeprotokol_detaljer.php

<?php
require_once( "../inc/mysql.php" );
$id = $_REQUEST["id"];


$sql = "
SELECT dato,enhed
FROM moedeprotokol
WHERE id = '{$id}'
";

$rows = query($sql);

$dato = $rows[0]->dato;

echo "<b>M&oslash;de detaljer for d. {$dato} </b><br><br>";

$sql = "
SELECT medlem,navn
FROM moededeltager
WHERE moedeid = {$id}
ORDER BY medlem DESC,navn ASC
";

$rows = query($sql);

echo "<table border='1'>";
echo "<tr><th colspan=2>Medlemmer</th></tr>";

$count = 1;
$nyeheader = false;
foreach($rows as $row) {
    
    if ($row->medlem == 0 && $nyeheader == false) {
        echo "<tr><th colspan=2>Nye</th></tr>";
        $nyeheader = true;
    }
    echo "<tr><td>{$count}</td><td>{$row->navn}</td></tr>\n";
    
    
    $count++;
}


?>
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	?>