What the following script does is that it gives a result of 4 rows, from the database, and generates 4 variables (newsbits0, newsbits1, newsbits2, newsbits3), and inserts result data into each of these variables.
What i want is a final 5th variable which contains all the data of the first 4 variables.. so that i can call that variable in my Flash file and display the result in one Dynamic Text field.. <?php $db = mysql_connect("localhost","user","pass"); mysql_select_db("myDB",$db); $result = mysql_query("SELECT substring_index(title,' ', 6) FROM news ORDER BY ID desc limit 4",$db); if (!mysql_num_rows($result)) { print 'no results'; } else { $count = 0; while (list($title) = mysql_fetch_row($result)) { print "&newsbits$count=$title"; ++$count; } } ?> Rahul S. Johari __________________________________________________ Do you Yahoo!? Yahoo! Web Hosting - establish your business online http://webhosting.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php