here is the fla … and php script…
<?
/*
// Part One - Initiate a mySQL Database Connection
// Database Connectivity Variables and other Variables
$DBhost = “nightspotz.com”; // Database Server
$DBuser = “nigolmvc_nigolmv”; // Database User
$DBpass = “********”; // Database Pass
$DBName = “nigolmvc_nightspotz”; // Database Name
$table = “guestbook”; // Database Table
// Connect to mySQL Server
$DBConn = mysql_connect($DBhost,$DBuser,$DBpass) or die("Error in GuestBook Application: " . mysql_error());
// Select mySQL Database
mysql_select_db($DBName, $DBConn) or die("Error in GuestBook Application: " . mysql_error());
// Part Two - Choose what action to perform
//Assign contents of form to variables
$email = $_POST[‘email’];
mysql_query ( "INSERT INTO contacts (email) VALUES (’$email’);
echo mysql_error();
mysql_close();
?>
