PHP, Flash, MySQL

programming
1

Some of you might have read my thread about getting data from a database, and with your help and some research I fixed that problem.

My new problem is taking data I receive from a database and having it to print to a dynamic text field in my swf.

http:/mynewwine.com is the page where I want the text to load (right side of the screen where it says ‘This week at new wine’. The actionscript is correct, of this I’m fairly certain.

http://mynewwine.com/getData.php is the file that retrieves the data from my database and echos it to the screen.

In my swf the variable for my text field is myVar. I read the tutorial on here and am stuck, I’ve looked around google as well. Below is my PHP script, I thought about adding print “myVar=$row”; but that doesn’t work. Any suggestions?

<html><head><title>Get Data</title></head>
<body>




<?php

include ("config.php");

$rs = @mysql_select_db( "newwine_admin" )
                         or die ( mysql_error() ) ;
						 
$sql="select id, date, time, details, event from schedule";

$rs = mysql_query( $sql );

while( $row = mysql_fetch_array( $rs ) )
{
   echo("Date: " . $row["date"] ."<br>");
   echo("Time: " . $row["time"] ."<br>");
   echo("Event: " . $row["event"] ."<br>");
   echo("Details: " . $row["details"] ."<br>");
   }
   
?>



</body></html>