[Attila]

Hej!

Denna block ska srolla meddelanden från databasen på min hemsida MEN
Den listar bara det första meddelandet som finna i databasen....varför? Någon som ser det?

<?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 10 senaste SMS
	$res = mysql_query('SELECT *,unix_timestamp(tstamp) as utstamp FROM sms
	ORDER BY tstamp DESC LIMIT 20');


// 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('ymd h:i',$row['utstamp']);


$content .="<div align=\"left\">";
$content .= "<marquee behavior= \"scroll\" loop=\"inifinite\" direction= \"up\" height=\"150\" width=\"97%\" scrollamount= \"1\" scrolldelay= \"25\">";
global $prefix, $dbi;
{
$content .="<div align=\"left\">";
$content .="<table class=\"outer\" cellpadding=\"\" style=\"border-collapse: collapse\"bordercolor=\"#FFFFFF\" cellspacing=\"1\" border=\"0\">";
$content .="<tr class=\"even\" vAlign=\"left\"><td align=\"left\">";
$content .="<td width=\"100%\"valign=\"left\">";
$content .= "$mess<br>";
//$content .= "<i>$date </i>";
$content .="</td></tr></table></div><hr></left>";
}
$content .="</marquee>";
$content .= "<br><br><div align=\"left\">";
$content .= "<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 .= "</center></div>";
?>