Hi All ok so I have a PHP file that Displays the 20 most recent posts in HTML form, now I wanna Send this Info to Flash Dymanic TXT box
but if i Add the "&" thing to this line echo "&toflash=$Passtoflash";PHP Code:<?php
error_reporting(E_ALL);
ini_set('display_errors', 'on');
$db = sqlite_open("MyDATABASEHERE.db", 0666, $sqliteerror)
or die($sqliteerror);
//echo "<p>Recent Posts</p>";
$sql = "SELECT * FROM phpbb_posts ORDER BY post_time DESC LIMIT 16";
//echo "<p>Query: " . $sql . "</p>";
$recent = sqlite_query($db, $sql)
or die(sqlite_error_string(sqlite_last_error()));
while ($recent_row = sqlite_fetch_array($recent, SQLITE_ASSOC))
{
// get data
$post_id = $recent_row['post_id'];
$topic_id = $recent_row['topic_id'];
$forum_id = $recent_row['forum_id'];
$poster_id = $recent_row['poster_id'];
$post_time = $recent_row['post_time'];
// get topic name
$topic_name = sqlite_query($db, "SELECT topic_title FROM phpbb_topics WHERE topic_id='$topic_id'");
$topic_name = sqlite_fetch_array($topic_name);
$topic_name = $topic_name['topic_title'];
// get username
$username = sqlite_query($db, "SELECT username FROM phpbb_users WHERE user_id='$poster_id'");
$username = sqlite_fetch_array($username);
$username = $username['username'];
//var for flash txt box is "toflash"
$Passtoflash = "$username posed in $topic_name<br />";
echo "&toflash=$Passtoflash";
}
?>
Flash reads only the very last post
If I remove the "&" thing from the line Flash Reads all data
but from the second row it adds toflash= to every line thereafter
This is what is returned in flash TXT box
EG:
Someone posed in Forum name
toflash=Someone posed in Forum name
toflash=Someone posed in Forum name
toflash=Someone posed in Forum name
toflash=Someone posed in Forum name
toflash=Someone posed in Forum name
toflash=Someone posed in Forum name
toflash=Someone posed in Forum name
toflash=Someone posed in Forum name
toflash=Someone posed in Forum name
toflash=Someone posed in Forum name
and so on
How do i get rid of toflash= ???
only First line reads correct
