Så ser det ut...nu med datum:
__________________________
// Anslut till databasen
mysql_connect($MYSQL_HOST, $MYSQL_USER, $MYSQL_PASSWORD);
mysql_select_db($MYSQL_DATABASE);
// Plocka ut 20 senaste SMS
$res = mysql_query('SELECT *,unix_timestamp(tstamp) as utstamp FROM sms
ORDER BY tstamp DESC LIMIT 20');
$content ="<div align=\"left\">";
$content .= "<marquee behavior= \"scroll\" loop=\"inifinite\" direction= \"up\" height=\"150\" width=\"97%\" scrollamount= \"1\" scrolldelay= \"25\" onmouseover='this.stop()' onmouseout='this.start()'>";
$content .= "<ul>";
// Gå igenom varje SMS - skriv ut tabellrader
while ($row = mysql_fetch_assoc($res)) {
// Plocka bort första ordet (prefix) ur meddelandet
$mess = substr($row['message'],strpos($row['message'],' '));
$date = date('y.m.d h:i',$row['utstamp']);
$content .= "[*]$mess
$date
<hr>";
}
$content .= "[/list]";
$content .="</marquee>";
$content .= "<div style=\"text-align:left;\">SMS-a hit DU med!!!
Gratta, flörta, fråga!
<a href=\"modules.php?name=Content&pa=showpage&pid=42 \">Läs mer</a>";
$content .= "</div>";
echo $content;
?>