[jpwrunyan]

How do you do the extremely simple task of sending vars from Flash to a PHP script to then insert into a database?

I have looked at countless examples and none of them seem to work!
Can someone please give me a working example? Nothing fancy... I just want to send vars to a php script which I then want to use to insert information into the database.

Actionscript:

dbinfo = new LoadVars();
dbinfo.insertWhere=2;
dbinfo.newName="my name";
dbinfo.newAge="27";
dbinfo.send("changeDB.php", "", "POST");

This above code should create a new LoadVars object, give it the values of insertWhere (the entry I want to change), newName (the name to put into the entry, replacing the old one), and newAge (ditto). Now, I don't need anything back... I just want to change the DB. Right now it keeps opening a new window which I don't want as well as just outright not working....

My PHP code is as follows:

PHP Code:

<?php 



$db = mysql_connect("server.net", "user", "password");

$newname=$_POST['sendName'];

$newscore=$_POST['sendScore'];

$changerank=$_POST['sendRank'];

$querryText="UPDATE `top10` SET `name` = $newname,`score` = $newscore,`shipConfig` = 'did this work?' WHERE `rank` = $changerank" ;



mysql_select_db("pwrdb",$db); 

mysql_query($querryText,$db);



?>

Please note this is merely an example of my latest failure... I have tried a ton of different things and none of them work. Someone please help me!