I have been trying to get a flash to do a database insert into mysql,
using a php script on my webserver:

<?php
$firstname = $_POST["firstname"];
$lastname = $_POST["lastname"];
$middlename = $_POST["middlename"];
$password = $_POST["password"];
$email = $_POST["email"];
$birthdate = $_POST["birthdate"];
$country = $_POST["country"];
$county = $_POST["county"];
$city = $_POST["city"];
$state = $_POST["state"];
$zip = $_POST["zip"];
$screenname = $_POST["screenname"];


$dbh = mysql_connect("localhost", "********", "******") or die ('I
cannot connect to the database because: ' . mysql_error());
mysql_select_db("****_******");

mysql_query('INSERT INTO userTable (county, firstName, middleName,
screenName, password, email, city, lastName, birthDate, zip, country,
state) VALUES ("'. $county .'", "' . $firstname . '", "' . $middlename
.. '", "' . $screenname . '", "' . $password . '", "' . $email . '", "'
.. $city . '", "' . $lastname . '", "' . $birthdate . '", "' . $zip .
'", "' . $country . '", "' . $state . '")', $dbh);
?>

I have the following AS written in a movie clip with one layer, and one
symbol, containing the text input boxes, labels, and button:

import mx.remoting.*;
import mx.rpc.*;
//import mx.remoting.debug.NetDebug;
import mx.utils.Delegate;
import mx.controls.Alert;


var submitListener:Object = new Object();
submitListener.click = function(evt:Object):Void {
var myVars:LoadVars = new LoadVars();

myVars.lastname = _level0.instance1.txtLastName.text;
myVars.firstname = _level0.instance1.txtFirstName.text;
myVars.middlename = _level0.instance1.txtMiddleName.text;
myVars.password = _level0.instance1.txtPassword.text;
myVars.email = _level0.instance1.txtEmail.text;
myVars.birthdate = _level0.instance1.txtBirthdate.text;
myVars.country = _level0.instance1.txtCountry.text;
myVars.county = _level0.instance1.txtCounty.text;
myVars.city = _level0.instance1.txtCity.text;
myVars.state = _level0.instance1.txtState.text;
myVars.zip = _level0.instance1.txtZip.text;
myVars.screenname = _level0.instance1.txtScreenName.text;

myVars.send("http://thegameofaphrodite.com/UserCreation.php");
this.lbl_message.text = "ok";
};
_level0.instance1.btnUserCreation.addEventListener ("click",
submitListener);

It also appears online at
[url]http://thegameofaphrodite.com/userCreation.swf[/url]

Thanks very much, must get this to work