# Need help and sample

**URL:** <https://forum.kirupa.com/t/need-help-and-sample/73100>\
**Category:** Uncategorized\
**Created:** [December 13, 2004, 1:49am UTC](https://forum.kirupa.com/t/need-help-and-sample/73100 "2004-12-13T01:49:07Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![olm75](https://avatars.discourse-cdn.com/v4/letter/o/8c91f0/32.png) [@olm75](https://forum.kirupa.com/u/olm75)\
**Post date:** [December 13, 2004, 1:49am UTC](https://forum.kirupa.com/t/need-help-and-sample/73100/1 "2004-12-13T01:49:07Z")

</div>

i’m looking for an sample .fla that searches a mysql database and sends the info back to flash…using PHP or anyother …  
or if u can help me with this

submit\_btn.onRelease = submitForm;  
function submitForm () {  
this.sendVar = new LoadVars();  
this.recvVar = new LoadVars();  
this.done = false;  
this.myData = new Array();  
this.sendVar.venuename = venuename.text;  
this.sendVar.state = state.getSelectedItem().label;  
this.sendVar.city = city.getSelectedItem().label;  
this.sendVar.areacode = areacode.text;  
this.sendVar.venuetype = venuetype.getSelectedItem().label;  
this.sendVar.agegroup = agegroup.getSelectedItem().label;  
this.sendVar.musictype = musictype.getSelectedItem().label;  
trace(“Sending " + this.sendVar.toString());  
this.sendVar.sendAndLoad(’/search.php’, this.recvVar, ‘POST’);  
this.getIt();  
};  
Loader.prototype.getIt = function() {  
// Self-reference for use inside function() calls  
var t = this;  
this.recvVar.onLoad = function(success) {  
if(success) {  
for(var i = 0; i \< this.total; i++) {  
t.myData[“venuename”+i].htmlText = “\<b\>”+this[“venuename”+i]+”\</b\>"  
t.myData[“address”+i].text = this[“address”+i]  
t.myData[“city”+i].text = this[“state”+i]  
t.myData[“zipcode”+i].text = this[“zipcode”+i]  
t.myData[“areacode”+i].text = this[“areacode”+i]  
t.myData[“phonenumber”+i].text = this[“phonenumber”+i]  
// Get the data, and…  
t.done = true;  
}  
}  
}  
};  
function doneTF(targ) {  
if(targ.done == true) {  
clearInterval(int\_doneTF);  
this.gotoAndPlay(“results”);  
}  
};  
// [EXECUTE]  
stop();  
var temp = new Loader();  
int\_doneTF = setInterval(this, ‘doneTF’, 50, temp);

stop();