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