You should pass the data to be imported into Flash through urlencode(). Flash needs the data to be urlencoded in order for it to be able to read it, particularly if the inputted data contains HTML, text with spaces, symbols, etc.
Mike -----Original Message----- From: Phil Clandillon [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 25, 2002 11:22 AM To: [EMAIL PROTECTED] Subject: newbie PHP/mySQL query Hi everyone, I'm using a very simple PHP script with mySQL to load a news feed (url encoded) into flash. I've got it working but I would like the records to come out in the opposite order, with the newest one first. This is the script: <?php $db = mysql_connect("localhost", "root", "pass"); mysql_select_db("sanchoDiary",$db); $sql="SELECT * FROM news"; $result=mysql_query($sql,$db); $num = mysql_num_rows($result); $cur = 1; echo "num=$num&newsFeed="; while ($num >= $cur) { $row = mysql_fetch_array($result); $newsposter = $row["newsposter"]; $newsitem = $row["newsitem"]; $link = $row["link"]; $datetime = $row["datetime"]; echo "<font color=\"#FF0000\"><b>$newsposter</b></font><font color=\"#663366\"><br>-----------------------------------------<br>$newsitem <br></font><font color=\"#FF00FF\"><u><b><a href=\"$link\" target=\"_blank\">$link</a></b></u></font><br>------------------------------ -----------<br><font size=\"-1\" color=\"#666666\">$datetime</font><br><br>"; $cur++; } echo "&newsLoaded=1&dummy=1"; ?> Can anyone help me to sort this out? cheers Phil Clandillon -------------------------------------------------- Graphic and Interactive Design -------------------------------------------------- work: http://www.clandillon.com play: http://www.mrming.co.uk --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php