flash mx AS not working going to mysql database using PHP…
// create a new loadVars object for the variables to send
varsToSend = new LoadVars();
myData = new Array();
varsToSend.venueName = venueName.text;
varsToSend.state = state.getSelectedItem().label;
varsToSend.city = city.getSelectedItem().label;
varsToSend.areaCode = areaCode.text;
varsToSend.venueType = venueType.getSelectedItem().label;
varsToSend.ageGroup = ageGroup.getSelectedItem().label;
varsToSend.musicType = musicType.getSelectedItem().label;
// include a variable to prevent cacheing - this forces the browser
// to make a new call to the server
varsToSend.clearCache = new Date().getTime();
// assign a variable to send - this will eventually come from the search box
varsToSend.myVar = “new”;
// create a new loadVars object for the variables to be received
varsToReceive = new LoadVars();
// set up the onload caller
varsToReceive.onLoad = processData;
// set up the function to be called on onLoad
function processData(success) {
// split the results into arrays using the “|” delimiter - this creates three arrays
//trace(“first pipe = " + varsToReceive.venueName);
venueNameArray = varsToReceive.venueName.split(”|");
addressArray = varsToReceive.address.split("|");
cityArray = varsToReceive.city.split("|");
zipCodeArray = varsToReceive.zipCode.split("|");
areaCodeArray = varsToReceive.areaCode.split("|");
phoneNumberArray = varsToReceive.phoneNumber.split("|");
stateArray = varsToReceive.state.split("|");
// format the text for the output box
for (i=0; i<venueNameArray.length; i++) {
outputText.text += venueNameArray* + " " + addressArray* + " " + cityArray* + " " + stateArray* + " " + zipCodeArray* + " " + areaCodeArray* + " - " + phoneNumberArray* + "
";
//trace(venueNameArray* + " " + addressArray* + “” + cityArray* + " " + zipCodeArray*+ " " + areaCodeArray* + " - " + phoneNumberArray*);
}
// tell the movie to go to the last frame label
_level0.gotoAndStop(“results”);
}
// do the send and load action - I put 127.0.0.1 (localhost)
// you’ll need to put your own domain name in
varsToSend.sendAndLoad(“search.php”, varsToReceive, “GET”);
stop();
