<?php
// Connect to database

require "dbconn.php";

// Copy the variables that the form placed in the URL
// into these three variables
$username = $_GET['username'];
$password = $_GET['password'];
$email = $_GET['email'];
$name = $_GET['name'];
$surname = $_GET['surname'];
$gender = $_GET['gender'];
$dob = $_GET['dob'];
$address1 = $_GET['address1'];
$address2 = $_GET['address2'];
$county = $_GET['county'];
$postcode = $_GET['postcode'];
$tel = $_GET['telephone'];
$mob = $_GET['mobile'];
$work = $_GET['work'];
$disab = $_GET['disab'];
$medication = $_GET['medication'];


// set up the query using the values that were passed via the URL from the form

$query = "INSERT INTO player VALUES ('','".$name."','".$surname."','".$gender."','".$dob."','".$email."','".$address1."','".$address2."','".$county."','".$postcode."','".$tel."','".$mob."','".$work."','','','','".$disab."','".$medication."','','')";
$query = "INSERT INTO login VALUES ('".$username."','".$password."','Player')";
// execute the query

$results = mysql_query($query)
                or die(mysql_error());

// jump to the next page

header( 'Location:regdone.php');
?>