I am trying to register a new user by posting their form data to the database via a php scriptregister.php but I am getting an array of errors when I hit register, the data is supposed to be validated by a second script called validate.php. My register.php is shown below. Same errors exist when the form is empty and when is filled.
<?php require('scripts/validate.php');?>
<!DOCTYPE html>
<html>
<head>
  <meta charset="UTF-8" />
  <title>Register</title>
<body>
 <div id="mainWrapper">
    <div id="register">
        <?php if(isset($error)){echo "<div id='error'>".$error."</div>";}?>
        <?php if(isset($success)){echo "<div id='success'>".$success."</div>";}?>
      <form method="post" action="" >
        <fieldset>
            <legend>Register Here</legend>
            <p>
            <label for="Username">Username</label>
            <input type="text" id="username"/>
            </p>
            <p>
            <label for="Email">Email</label>
            <input type="text" id="email"/>
            <p>
            <label for="Firstname">Firstname</label>
            <input type="text" id="firstname"/>
            </p>
            <p>
            <label for="Lastname">Lastname</label>
            <input type="text" id="lastname"/>
            </p>
            <p>
            <label for="Password">Password</label>
            <input type="password" id="password"/>
            </p>
            <p>
            <label for="Re-Type Password">Re-Type Password</label>
            <input type="password" id="password2"/>
            </p>
            <p>
            <label for="DOB">DOB</label>
            <input type="text" id="dob">
            </p>
            <p>
            <label for="Adress">Adress</label>
            <input type="text" id="address"/>
            </p>
            <p>
            <label for="Adress 2">Adress 2</label>
            <input type="text" id="address2"/>
            </p>
            <p>
            <label for="town">Town</label>
            <input type="text" id="town"/>
            </p>
            <p>
            <label for="county">County</label>
            <input type="text" id="county"/>
            </p>
            <p>
            <label for="Postalcode">PostalCode</label>
            <input type="text" id="postcode"/>
            </p>
            <p>
            <label for="contactno">Contact No.</label>
            <input type="text" id="contact"/>
            </p>
          <input type="submit" name="submit" value="Register"/>
            </fieldset>
            </form>
            </div>
        </div>
</body>
</html>
And the validate.php is here
   <?php include('connection.php');?>
    <?php
    if(isset($_POST['submit']))
    {
    $username=$_POST['username'];
    $email=$_POST['email'];
    $firstname=$_POST['firstname'];
    $lastname=$_POST['lastname'];
    $password=$_POST['password'];
    $password2=$_POST['password2'];
    $dob=$_POST['dob'];
    $address=$_POST['address'];
    $address2=$_POST['address2'];
    $town=$_POST['town'];
    $county=$_POST['county'];
    $postcode=$_POST['postcode'];
    $contact=$_POST['contact'];
    $fetch=mysql_query("SELECT id FROM users WHERE email='$email'")or die(mysql_error());
    $num_rows=mysql_num_rows($fetch);
    if(empty($username)||empty($email) || empty($firstname) || empty($lastname) || empty($password) || empty($password2)  || empty($dob) || empty($address) || empty($town)|| empty($postcode) || empty($contact))
    {
        $error= 'ALl * fields are required';
    }
    elseif (!filter_var($email,FILTER_VALIDATE_EMAIL)) 
    {
    $error= 'A valid email is required';
    }
    elseif (!empty($contact)) 
    {
       if (!is_numeric($contact)) 
         {
           $error= 'Enter a valid contact No.';
         }  
    }
    elseif ($password !=$password2) 
    {
    $error= "Passwords don't match";
    }
    elseif ($num_rows >=1)
     {
        $error='We already have this email registered,try a new one!';
     }
    else
        {
            $password=md5($password);
            $sql=mysql_query("INSERT INTO user(username,email,firstname,lastname,password,dob,address,address2,town,county,postcode,contact)VALUES('$username','$email','$firstname','$lastname','$password','$dob','$address','$address2','$town','$county','$postcode','$contact')");
        if($sql)
        {
    header("location:login.php");   
        }
       }
}
?>
I'll greatly appreciate guys.
 
     
     
     
     
     
     
    