[nuttycoder]

I have managed to get some data from a mysql database into flash the problem is I can only get one row when I know there is three rows.

here's my actionscript:

This is on the frame so it loads the data as soon as you enter it

Code:

loadVariables("news.php", "POST");

My php script to get the data from the database

PHP Code:

query = "SELECT * FROM flash_news";

$result = mysql_query($query) or die('Error : ' . mysql_error());



while($row = mysql_fetch_array($result)){        





    $row['newsTitle'] = stripslashes($row['newsTitle']);

    $row['newsCont'] = stripslashes($row['newsCont']);



    

echo "&mynews=<b>Title</b>: " . $row['newsTitle'] . "<br><b>Cont</b>: " . $row['newsCont'];



} 

Anyone know why I can only get 1 row when there is more rows?

[hinch]

Are you sure your text box is set to wrap? I make that mistake sometimes, thinking something isn't working when really it's just off the screen.

[nuttycoder]

Wish that was it cos then it would be fixed

I have my text box set to Multiline so it will wrap even if it wasen't I have set the render text as HTML checked so its goes on to the next line after each title or content is echoed out using the <br> tag.

I think its something to do with it's only reading the latest result but not getting all the loops from php inside the while loop but this is just a guess.

[hinch]

PHP Code:

<?php
$result = mysql_query("SELECT * FROM flash_news LIMIT=1") 
or die "<h2>Could not select config</h2>";

while($row = mysql_fetch_array($result)) {

        $title = $row['newsTitle'];
        $content = $row['newsCont'];

echo"<h1>Title: $title</h1>\n <br /> Cont: $content \n";
}
?>

That will list the most recent content in your table (depending how it's set, you may need to sort it using 'ORDER by'). It's probably better using 'WHERE' than 'LIMIT' also but that's up to you.

Does your PHP file work correctly on it's own? Is it tested outside of Flash?

[nuttycoder]

I don't want to limit the results I want to see all records in the table. I''ve tested the php file in a browser and it works fine but not in flash its almost like its not looping when it goes into flash.

[hinch]

Maybe you could zip and upload your code so far for someone to look at. It's a while since I did the same.

What version of Flash are you using? Try exporting it with different action script settings, it can be a great way to find some dodgy code sometimes.

[blinn_shade]

What happens when you visit the news.php file? Can you paste what you see please.