# \[MX2004\]PHP -\> Flash

**URL:** <https://forum.kirupa.com/t/mx2004-php-flash/31217>\
**Category:** flash\
**Created:** [September 19, 2003, 4:22pm UTC](https://forum.kirupa.com/t/mx2004-php-flash/31217 "2003-09-19T16:22:51Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Lews](https://avatars.discourse-cdn.com/v4/letter/l/f0a364/32.png) [@Lews](https://forum.kirupa.com/u/Lews)\
**Post date:** [September 19, 2003, 4:22pm UTC](https://forum.kirupa.com/t/mx2004-php-flash/31217/1 "2003-09-19T16:22:51Z")

</div>

I’m trying to get text from a database into Flash via PHP/MySQL.  
While this works perfectly outside of Flash (ie. the text shows up fine if I just open the PHP file), I get an “undefined” in my textbox when I try to get the text in Flash.

My PHP file: (this may be sloppy, I’m still a beginner ;))

```php

<?PHP
                include ("conf.php");
	$dh= $HTTP_POST_VARS["Page"];
	$query = "SELECT * FROM denhaag WHERE ID = '1'";
	$result = mysql_query($query)
	or die (mysql_error());
	
	while ($data = mysql_fetch_assoc($result)) {
	extract ($data);
	
	if ($dh == 'huis') {
		$huis = $data['huis'];	
		echo "$huis";
	}

	elseif ($dh == 'uitgaan') {
		$uitgaan = $data['uitgaan'];	
		echo "$uitgaan";
	}
	
		
	elseif ($dh == 'sport') {
		$sport = $data['sport'];	
		echo "$sport";
	}
	
	
	elseif ($dh == 'geschied') {
		$geschied = $data['geschied'];	
		echo "$geschied";
	}

	elseif ($dh == 'student') {
		$student = $data['student'];	
		echo "$student";
	}

	else {
		$home = $data['home'];	
		echo "$home";
	}

} ;

?>

```

This code is in a button in Flash:

```auto

on(release)
{
	Send = new LoadVars();
	Received = new LoadVars();
	
	Page = "huis";
	Send.Page= Page;
	
	Send.sendAndLoad("dh.php",Received);
	ReceivedText= Received.huis;
	Test.text = ReceivedText;
}

```

Any ideas?