Insert into new table
Posted: Sun Apr 20, 2008 6:49 am
Hi all.
I hope you can help me with this.
I'm using macromedia flash to send data to php to mysql.
It works perfectly, but I want to put the received data in a new table each time.
How do I do that?
Here is my code...
I hope you can help me with this.
I'm using macromedia flash to send data to php to mysql.
It works perfectly, but I want to put the received data in a new table each time.
How do I do that?
Here is my code...
Code: Select all
<?php
$DBhost = "localhost";
$DBuser = "root";
$DBpass = "************";
$DBName = "DB";
$table = "Table";
$Var01 = $_POST['Var01'];
$Var02 = $_POST['Var02'];
$Var03 = $_POST['Var03'];
mysql_connect($DBhost,$DBuser,$DBpass) or die("Unable to connect to database");
@mysql_select_db("$DBName") or die("Unable to select database $DBName");
$sqlquery = "INSERT INTO $table VALUES('$id','$Var01','$Var02','$Var03')";
$results = mysql_query($sqlquery);
mysql_close();
?>