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