Passwords do not match, please try again";} else { $s="SELECT COUNT(*) as C FROM MR_coaches WHERE Email='$Email'"; $query=$con->query($s); $a=$query->fetch_assoc(); if ($a['C'] < 1){ $sql2="INSERT INTO MR_schools (School, SchoolCode) VALUES ('$School', '')"; $q2=$con->query($sql2); $SchoolID=mysqli_insert_id($con); $sql="INSERT INTO MR_coaches (FN, LN, School, Phone, Email, PW) VALUES ('$FN', '$LN', '$SchoolID', '$Phone', '$Email', '$PW')"; $q=$con->query($sql); $CoachID=mysqli_insert_id($con); $sql="INSERT INTO MR_Teams (CoachID, Name) VALUES('$CoachID', '$School')"; $con->query($sql); $ErrorMsg="Your account has been successfully created. Click HERE to login!"; } else { $ErrorMsg="This Email Address has already been used for an account. Please use a different account or the \"Forgot Password\" App .";} } }?> TheMeetResults.com

placeholder="First Name"required/>
placeholder="Last Name" required/>
placeholder="Full School Name (No abbreviations)" required/>
placeholder="Phone" required/>
name="Email" placeholder="Email" required/>
I already have an account