Gegevens in database uploaden

// Stap 2
elseif($_GET['action'] == add && $_GET['step'] == 2)
{
	if(!$sub)
	{
		$naam = $soort." ".$weekdag." ".$dag." ".$maand." ".$jaar;
		$sql = "INSERT INTO wedstrijdprogramma (naam) VALUES ('$naam')";
		$result = mysql_query($sql);
		$id = mysql_insert_id();
		$dbNaam = "wp".$id;
		$sql = "CREATE TABLE ".$dbNaam." (
		`id` TINYINT NOT NULL AUTO_INCREMENT PRIMARY KEY, 
		`nummer` VARCHAR(10), 
		`club1` VARCHAR(30), 
		`team1` VARCHAR(10), 
		`club2` VARCHAR(30), 
		`team2` VARCHAR(10), 
		`tijd` VARCHAR(10), 
		`scheidsrechter` VARCHAR(30)
		);";
		$result = mysql_query($sql);	
	}
	echo("<form name='f002' method='post' action='".$PHP_SELF."?action=add&step=3'>");
	echo("<input name='dbNaam' type='hidden' value='$dbNaam'>");
	echo("<input name='naam' type='hidden' value='$naam'>");
?>

// Stap 2
elseif($_GET['action'] == add && $_GET['step'] == 2)
{
	if(!$sub)
	{
		$naam = $soort." ".$weekdag." ".$dag." ".$maand." ".$jaar;
		$sql = "INSERT INTO wedstrijdprogramma (naam) VALUES ('$naam')";
		$result = mysql_query($sql);
		$id = mysql_insert_id();
		$dbNaam = "wp".$id;
		$sql = "CREATE TABLE ".$dbNaam." (
		`id` TINYINT NOT NULL AUTO_INCREMENT PRIMARY KEY, 
		`nummer` VARCHAR(10), 
		`club1` VARCHAR(30), 
		`team1` VARCHAR(10), 
		`club2` VARCHAR(30), 
		`team2` VARCHAR(10), 
		`tijd` VARCHAR(10), 
		`scheidsrechter` VARCHAR(30)
		);";
		$result = mysql_query($sql);	
	}
	echo("<form name='f002' method='post' action='".$PHP_SELF."?action=add&step=3'>");
	echo("<input name='dbNaam' type='hidden' value='$dbNaam'>");
	echo("<input name='naam' type='hidden' value='$naam'>");
?>

// Stap 3
elseif($_GET['action'] == add && $_GET['step'] == 3)
{
	$team1 = $team1_1.$team1_2;
	$team2 = $team2_1.$team2_2;
	$tijd = $tijd1.":".$tijd2;
	$sql = "INSERT INTO ".$dbNaam." (nummer,club1,team1,club2,team2,tijd,scheidsrechter) VALUES ('$nummer','$club1','$team1','$club2','$team2','$tijd','$scheidsrechter')";
	$result = mysql_query($sql);
	if ( $result != false )
	{
		echo "<span class='standaard'>Wedstrijd toegevoegd</span><br>";
	} 
	else 
	{
		die(mysql_error());
	}
echo("<form name='f003' method='post' action='".$PHP_SELF."?action=add&step=2&sub=1'>");
echo("<input name='dbNaam' type='hidden' value='$dbNaam'>");
echo("<input name='naam' type='hidden' value='$naam'>");
?>

// Stap 3
elseif($_GET['action'] == add && $_GET['step'] == 3)
{
	$team1 = $team1_1.$team1_2;
	$team2 = $team2_1.$team2_2;
	$tijd = $tijd1.":".$tijd2;
	$sql = "INSERT INTO ".$dbNaam." (nummer,club1,team1,club2,team2,tijd,scheidsrechter) VALUES ('$nummer','$club1','$team1','$club2','$team2','$tijd','$scheidsrechter')";
	$result = mysql_query($sql);
	if ( $result != false )
	{
		echo "<span class='standaard'>Wedstrijd toegevoegd</span><br>";
	} 
	else 
	{
		die(mysql_error());
	}
echo("<form name='f003' method='post' action='".$PHP_SELF."?action=add&step=2&sub=1'>");
echo("<input name='dbNaam' type='hidden' value='$dbNaam'>");
echo("<input name='naam' type='hidden' value='$naam'>");
?>