[koala]

Läste koden lite slarvigt... det här bör funka bättre. Tog mig friheten att radera en massa överflödig html för tydlighetens skull...

<?php
/************************************************************************/
/* Copyright (c) 200 by Attila Gál             */
/*  Bålsta, SWE                           */
/* Version 1 - Scrolling SMS List -Block oct 8, 2006       */
/*                                   */
/* This block shows the latest 10 SMS on your site!        */
/************************************************************************/
if (eregi("block-Scrolling_SMS.php",$PHP_SELF)) {
  Header("Location: index.php");
die();
}

$MYSQL_HOST = '********';
$MYSQL_USER = '********';
$MYSQL_PASSWORD = '********';
$MYSQL_DATABASE = '********';

// 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>";

$content .= "<marquee behavior= \"scroll\" loop=\"inifinite\" direction= \"up\" height=\"150\" width=\"97%\" scrollamount= \"1\" scrolldelay= \"25\">";

$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'],' '));
	$content .= "<li>$mess</li>";
}
$content .= "</ul>";

$content .="</marquee>";

$content .= "<div style="text-align:center;">SMS-a hit DU med!!!<br>Gratta, flörta, fråga!<br><a href=\"modules.php?name=Content&pa=showpage&pid=42\">Läs mer</a>";
$content .= "</div>";

$content .= "</div>";

echo $content;

?>