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