[jpwrunyan]

Hello, I have been trying to figure out how to get my flash files to cooperate with my php file to get some variables from my database.

Now I really just want to start small. I have looked at examples on the internet and they are invariable too complicated! Full of tom-foolery that is confusing and obstuctive!

Could someone please, oh please, just give me a simple example of how to get variables from mySQL into Flash? And only that?

I have a database: mydb
in that database I have a table: friends
friends has two fields: name, age
there are is a list of friends and their ages...

now... how can I get this into an array or an object in flash?
I have been trying very rudimentary things and it hasn't worked. I want to use POST when I call the php file...

so far I have been trying this (I may have a few mispellings...):

showVars = function () {
trace (this.flash_var_name+", "+this.flash_var_age);
}

flash_loadvar = new LoadVars();
flash_loadvar.onLoad = showVars;
flash_loadvar.LoadVars("getFriends.php", _self, "POST");

this is the best I have been able to infer from examples I have looked at so far... there may be a problem with my sql as well...
any help would be greatly appreciated!