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