[PHP] send data from flash to mySQL problem

programming
1

I’m trying to get a grip on Flash AS and PHP interaction.

This Flash ActionScript is supposed to send a variable (myData.email) found in a dynamic textbox to a PHP-script (when a button is pushed):

myData.name = name;
myData.stime = stime;
myData.score = score;
myData.total = total;
myData.email = email.text;
myData.sendAndLoad("highscore.php", myData, "POST");

Then this PHP-script is supposed to add this varible to MySQL:

<?php
//Capture data from $_POST array
$name = $_POST[‘name’];
$total = $_POST[‘total’];
$score = $_POST[‘score’];
$stime = $_POST[‘stime’];
$email = $_POST[‘email’];
$date = date(“Y-m-d”);
//Connection to database
include(“config.php”);
$db = @mysql_connect($host_name, $user_name, $host_password);
mysql_select_db($db_name);
//Perform the query
$sql = “INSERT into $table_name (name, stime, score, total, ‘email’, date) VALUES (’$name’, ‘$stime’, ‘$score’, ‘$total’, ‘$email’, ‘$date’)”;
//
$res = mysql_query($sql, $db);
?>

The problem is:
They all work except the email one?

  • when i take off email it all works and my database gets updated.
  • when i add it nothing works.

Any suggestions?