misc/horsensspejder-web/outbox.php

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

<h3>Udbakke</h3>
<?php

$rows = query("
select o.id,receiver,message,status,statustime, fornavn,efternavn 
from outbox o
left join stamdata d on ( right(o.receiver, 8) = right(d.mobil, 8) )
group by o.id
order by id desc
");

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


$i = 0;

foreach($rows as $row) {
        $message = utf8_decode( $row->message ) ;
        $style = ($i == 0) ? "even" : "odd";
        echo "<tr class='{$style}'><td>{$row->receiver}</td><td>{$row->fornavn} {$row->efternavn}</td><td>{$message}</td><td>{$row->status}</td><td>{$row->statustime}</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	<h3>Udbakke</h3>
7	<?php
8
9	$rows = query("
10	select o.id,receiver,message,status,statustime, fornavn,efternavn
11	from outbox o
12	left join stamdata d on ( right(o.receiver, 8) = right(d.mobil, 8) )
13	group by o.id
14	order by id desc
15	");
16
17	echo "<table border='0'>";
18	echo "<tr><th width='100'>Modtager</th><th>Navn</th><th width='400'>Tekst</th><th>Status</th><th>Tid</th></tr>\n";
19
20
21	$i = 0;
22
23	foreach($rows as $row) {
24	$message = utf8_decode( $row->message ) ;
25	$style = ($i == 0) ? "even" : "odd";
26	echo "<tr class='{$style}'><td>{$row->receiver}</td><td>{$row->fornavn} {$row->efternavn}</td><td>{$message}</td><td>{$row->status}</td><td>{$row->statustime}</td></tr>\n";
27
28	$i = ($i+1)%2;
29	}
30	echo "</table>";
31
32
33	require("footer.php");
34	?>