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