importing text from MySql to flash

[janak]

hi,
could someone please tell me how i can load text from mysql database into a flash movie clip I have made!!

Thanks
Janak

[nnichols]

Have a look at this tutorial -

http://www.phpbuilder.com/columns/hill20011214.php3

it gives some example of how to use ActionScript to interact with PHP/MySQL.

Hope this helps

[janak]

Thanks for the link, as i am fairly new to PHp & mySql, i think most of the tutorial just went over my head....🙁

The hunt continues...

[janak]

PROGRESS REPORT:

Hi Again,
Just to explain my question in detail. I have a php page (dbtext.php) that is getting the data from mysql database. And on the same page is a SWF file with dynamic text box.

I am trying to import the data from mysql to this flash file.

When i have tried to output the result using echo (without flash) it works fine, just that I cannot get it to work in flash

Here is the code I am using on my dbtest.php page:

<?php 
$page = $_GET['page'];
if (($page == "")){
$page = "home";
}
$connect = @mysql_connect("localhost","user","pass") or die("cannot connect"); 
mysql_select_db("databasename"); 
//$query = "SELECT * FROM pages"; 
$sql = "SELECT * FROM pages WHERE page = '$page'";
$result = mysql_query($sql) or die("Query failed"); 
$row = mysql_fetch_array($result);
print "&textbox=".urlencode($row['text']); 
mysql_free_result($result); 
mysql_close( $connect ); 
?>

Here is the code that I have used in the SWF file

onClipEvent (load) {
loadVariables("dbtest.php", this, "GET");
}

The results I get are very weird. view them at www.janaksingh.co.uk/php/dbtest.php

[janak]

I am starting to loose hope, but maybe someone can help afterall

[nnichols]

Have a look through the tutorials here -

http://www.sephiroth.it/tutorials/flashPHP/

There should be something there that can help you.