-
last field soed not show
Hello,
I am trying to load a number of events through php and mysql, but the last field form the last row shows. This implies that for all events but the last the hyperlink doesn't show. Did anyone maybe encounter this already, or is there someone around who could point me to an error in my code?
This is the AS:
function showContent() {
var i;
content.htmlText = "";
for (i=0; i < this.n; i++)
{
if (this["title"+i] != "") {
content.htmlText += "<font color='#FF6600'><b>" + this["title"+i]+ "</b></font>" + "<br><b>" + this["city"+i]+ "</b><br>" + this["teaser"+i]+ "<br><br><u><a href='"+ this["regtext"+i]+"'target='_blank'>"+ this["regtext"+i]+"</a></u><br><br>";
}
else
{
content.htmlText += "<b>no events</b><br>";
}
}
}
var start = 0 ;
var send = new LoadVars();
send.onLoad = showContent;
send.sendAndLoad("http://xxxxxxxxx/xxxxxx.php?init="+start,send,"POST");
stop();
And this the php script:
$qr = mysql_query("SELECT title, teaser, city, regtext, DATE_FORMAT(FROM_UNIXTIME(enddate), '%d %M %Y') AS enddate FROM tx_julleevents_events WHERE pid = '414' AND deleted = '0' AND enddate > $date_today_u ");
$nrows = mysql_num_rows($qr);
$rString = "n=".$nrows."&today=".$date_today."&today_u=".$dat e_today_u;
for ($i=0; $i < $nrows; $i++) {
$row = mysql_fetch_array($qr);
$rString .= "&title".$i."=".$row['title']."&city".$i."=".$row['city']."&enddate".$i."=".$row['enddate']."&teaser".$i."=".$row['teaser']."®text".$i."=".$row['regtext'];
}
echo $rString;
When i load the php page itself the echo goes perfectly well, which makes me assume that it must be going wrong in Flash somewhere.
Thanks in advance for any help or hints!
Tim Loenders