misc/horsensspejder-web/inbox.php

<?php
require("header.php");
include "inc/mysql.php";
?>


<h3>Indbakke</h3>

<?php

$rows = query("
select i.id,sender,receivetime,body,fornavn,efternavn from 
inbox i
left join stamdata d on ( right(i.sender, 8) = right(d.mobil, 8) )
group by i.id
order by receivetime desc
");


echo "<table border='0'>";
echo "<tr><th width='100'>Afsender</th><th>Navn</th><th width='160'>Tid</th><th width='400'>Tekst</th></tr>\n";


$i = 0;

foreach($rows as $row) {
        $style = ($i == 0) ? "even" : "odd";
        echo "<tr class='{$style}'><td>{$row->sender}</td><td>{$row->fornavn} {$row->efternavn}</td><td>{$row->receivetime}</td><td>{$row->body}</td></tr>\n";

        $i = ($i+1)%2;
}
echo "</table>";


require("footer.php");
?>
1	torben	2125	<?php
2			require("header.php");
3			include "inc/mysql.php";
4			?>
5
6
7			<h3>Indbakke</h3>
8
9			<?php
10
11			$rows = query("
12			select i.id,sender,receivetime,body,fornavn,efternavn from
13			inbox i
14			left join stamdata d on ( right(i.sender, 8) = right(d.mobil, 8) )
15			group by i.id
16			order by receivetime desc
17			");
18
19
20			echo "<table border='0'>";
21			echo "<tr><th width='100'>Afsender</th><th>Navn</th><th width='160'>Tid</th><th width='400'>Tekst</th></tr>\n";
22
23
24			$i = 0;
25
26			foreach($rows as $row) {
27			$style = ($i == 0) ? "even" : "odd";
28			echo "<tr class='{$style}'><td>{$row->sender}</td><td>{$row->fornavn} {$row->efternavn}</td><td>{$row->receivetime}</td><td>{$row->body}</td></tr>\n";
29
30			$i = ($i+1)%2;
31			}
32			echo "</table>";
33
34
35			require("footer.php");
36			?>