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