Creating new table in databse everyday

programming
1

Hello, i am working a flash project on attendance , when i submit the attendance, i want to create a new table for everyday.
the table should be based on the module course and the date
But i got problem of it, it doesnt create new table when i submit the attendance. Coudl somebody help me?/ thz

i declare
//today’s date
$date=date(“d”."/".“m”.",".“y”);
//the new table, is it correct??
$newtable=$_POST[‘moduleName’].$_POST[‘courseName’].$date;
There is part of the program


//today's date 
$date=date("d"."/"."m".","."y");
$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}
if ((isset($_POST["RC_insert"])) && ($_POST["RC_insert"] == "form1")) {
//the new table, is it correct??
$newtable=$_POST['moduleName'].$_POST['courseName'].$date;
  $createSQL = sprintf("Create TABLE $newtable (studentNO varchar(9),time varchar(40),moduleName varchar(255),courseName varchar(255));");
  $insertSQL = sprintf("INSERT INTO record (studentNO, time, moduleName, courseName) VALUES (%s, %s, %s, %s)",
            GetSQLValueString($_POST['studentNO'], "text"),
            GetSQLValueString($_POST['Time'], "text"),
   GetSQLValueString($_POST['moduleName'], "text"),
   GetSQLValueString($_POST['courseName'], "text"));
  mysql_select_db($database_flash_agent, $flash_agent);
  $Result1 = mysql_query($createSQL, $flash_agent) or die(mysql_error());
  $Result1 = mysql_query($insertSQL, $flash_agent) or die(mysql_error());
}