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