# loadVariables
**URL:** https://forum.kirupa.com/t/loadvariables/24834
**Category:** Uncategorized
**Created:** [July 5, 2003, 6:30pm UTC](https://forum.kirupa.com/t/loadvariables/24834 "2003-07-05T18:30:48Z")
**Posts on this page:** 10
**Page:** 1
### Author:  [@Voetsjoeba](https://forum.kirupa.com/u/Voetsjoeba)
#### Post date: [July 5, 2003, 6:30pm UTC](https://forum.kirupa.com/t/loadvariables/24834/1 "2003-07-05T18:30:48Z")
Hi everyone š
I am trying to get data from a MySQL database into Flash. In flash, I have
[AS]
loadVariables(ānews.phpā,ācontentā);
[/AS]
on the first frame of the main movie where content is the movieclip the variables should be loaded into. Inside content, I have a dynamic text field with the var āinhoudā. On the left of that dynamic textfield, there is an empty movieclip called āimgā, in which an image should load. So on that movieclip I have
[AS]
onClipEvent(load){
\_parent.img.loadMovie(āhomeā+i+".jpg");
}
[/AS]
Now, the php file ānews.phpā contains the following:
```php
```
( Thanks a million to Jubba for helping me out with the PHP :love: )
This doesnāt work. Why not ?
---
### Author:  [@system](https://forum.kirupa.com/u/system)
#### Post date: [July 5, 2003, 7:51pm UTC](https://forum.kirupa.com/t/loadvariables/24834/2 "2003-07-05T19:51:25Z")
getURL(url, target, **METHOD** )
mthod: POST or GET
---
### Author:  [@system](https://forum.kirupa.com/u/system)
#### Post date: [July 5, 2003, 7:54pm UTC](https://forum.kirupa.com/t/loadvariables/24834/3 "2003-07-05T19:54:47Z")
heās trying to load the data into Flash. Not display the PHP page.
---
### Author:  [@system](https://forum.kirupa.com/u/system)
#### Post date: [July 5, 2003, 8:10pm UTC](https://forum.kirupa.com/t/loadvariables/24834/4 "2003-07-05T20:10:27Z")
I can see many errorsā¦ besides, use LoadVars
```auto
lv = new LoadVars()
lv.onLoad = function(success) {
if (success) {
i = this.i;
trace(i)
img = this.img;
trace(img);
datum = this.datum;
trace(datum);
inhoud = this.inhoud;
trace(inhoud);
_root[img].loadMovie("home"+i+".jpg");
} else {
trace("failed to load script");
}
}
lv.load("news.php")
```
try that, let me know how it goes š
---
### Author:  [@system](https://forum.kirupa.com/u/system)
#### Post date: [July 5, 2003, 8:39pm UTC](https://forum.kirupa.com/t/loadvariables/24834/5 "2003-07-05T20:39:06Z")
Ok, Iāll try that š Thanks ahmed š
---
### Author:  [@system](https://forum.kirupa.com/u/system)
#### Post date: [July 6, 2003, 10:27am UTC](https://forum.kirupa.com/t/loadvariables/24834/6 "2003-07-06T10:27:05Z")
A part works ! š I added an extra textfield on top to display the amount of rows. In that textbox, it is supposed to fill in the value of the varibale āiā, which it got out of the PHP script. This is a good sign, because I know now that it did recieve the variables. But the other fields didnāt get filled in ā¦ Is it possible that I have to change ādatum = this.datumā to āthis.datum = datumā ? Iām not sure what the variable is and what the path to the textfield is here ā¦ š
---
### Author:  [@system](https://forum.kirupa.com/u/system)
#### Post date: [July 6, 2003, 10:41am UTC](https://forum.kirupa.com/t/loadvariables/24834/7 "2003-07-06T10:41:42Z")
> \*Originally posted by Voetsjoeba \*
> \*\*is it possible that I have to change ādatum = this.datumā to āthis.datum = datumā ? Iām not sure what the variable is and what the path to the textfield is here ā¦ š \*\*
> noā¦ can i see a dummy FLA?
---
### Author:  [@system](https://forum.kirupa.com/u/system)
#### Post date: [July 6, 2003, 11:27am UTC](https://forum.kirupa.com/t/loadvariables/24834/8 "2003-07-06T11:27:17Z")
Well, Iāve set up a SWF online to test he variables, you can see it here: [http://voetsjoeba.xszone.nl/test/test.html](http://voetsjoeba.xszone.nl/test/test.html) and the swf fle is [http://voetsjoeba.xszone.nl/test/test.swf](http://voetsjoeba.xszone.nl/test/test.swf) . Maybe the SWF is better to see, cuz the font size is quite small ā¦
It fills in i (3), which is correct, but it doesnāt recognise the other variables, āinhoudā en ādatumā. Iāll post the dummy FLA in a sec.
---
### Author:  [@system](https://forum.kirupa.com/u/system)
#### Post date: [July 6, 2003, 11:36am UTC](https://forum.kirupa.com/t/loadvariables/24834/9 "2003-07-06T11:36:53Z")
```php
$output="";
$output.= "&i=".$nrows;
$output.= "&img".$i."=".$row['img'];
$output.= "&datum".$i."=".$row['datum'];
$output.= "&inhoud".$i."=".$row['inhoud'];
}
```
if you get rid of the $i, it would work š
---
### Author:  [@system](https://forum.kirupa.com/u/system)
#### Post date: [July 6, 2003, 11:42am UTC](https://forum.kirupa.com/t/loadvariables/24834/10 "2003-07-06T11:42:30Z")
Thanks =) Lemme try.
[EDIT] It works !!! Thank you thank you thank you !![/EDIT]