# Mysql -\> Flash

**URL:** <https://forum.kirupa.com/t/mysql-flash/211928>\
**Category:** flash\
**Created:** [January 6, 2007, 3:09pm UTC](https://forum.kirupa.com/t/mysql-flash/211928 "2007-01-06T15:09:42Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![freaked\_out](https://avatars.discourse-cdn.com/v4/letter/f/58f4c7/32.png) [@freaked\_out](https://forum.kirupa.com/u/freaked_out)\
**Post date:** [January 6, 2007, 3:09pm UTC](https://forum.kirupa.com/t/mysql-flash/211928/1 "2007-01-06T15:09:42Z")

</div>

Hi people

I’m trying to fetch data from my mysql db to my flash site (news items).  
I’ve made a .php file, but I don’t know how to put this into a flash dynamic text box :\*(

I’ve been doing tuts for many days but I just can’t get it to work.

I’ll append my get.php file. Any help appreciated!

\<?php  
$server = “localhost”;  
$user = “username”;  
$pass = “password”;  
$database = “pgrimcen\_news”;  
$tableName = “newsnews”;  
$conn = @mysql\_connect($server,$user,$pass);  
$database = @mysql\_select\_db($database,$conn);  
$query = @mysql\_query(“SELECT id, subject, titletext, maintext FROM $tableName”);  
$total\_rows = @mysql\_num\_rows($query);  
$counter = 0;  
while($ourData = @mysql\_fetch\_array($query)){  
$id = $ourData[“id”];  
$subject = $ourData[“subject”];  
$titletext = $ourData[“titletext”];  
$maintext = $ourData[“maintext”];  
$counter++;  
print($id.$subject.$titletext.$maintext);  
}  
print("&total=$total\_rows");  
?\>