<?php
    //Access database connection.
    include("../functions/dbconnection.php");

    //Get client contact details from form.
             $firstName = $_POST['firstName'];
             $lastName = $_POST['lastName'];
             $address = $_POST['address'];
             $phoneNumber = $_POST['phoneNumber'];
             $emailAddress = $_POST['emailAddress'];

     //Get client desired login details from form.
             $userName = $_POST['userName'];
             $password = $_POST['password'];

    //Insert user data into user table.
    $addClient="INSERT INTO client (firstName, lastName, address, phoneNumber, emailAddress)
                VALUES ('$firstName', '$lastName', '$address', '$phoneNumber', '$emailAddress')";
    $addResult= mysql_query($addClient);

    //If client submits a user name.
    if(isset($userName))
    {
    //Get user ID
    $userID=mysql_insert_id();

    //Insert the user details.
    $addUser="INSERT INTO users (userID, userName, password)
              VALUES ($NULL, '$userID', '$userName', '$password')";
    $addResult=mysql_query($addUser);
    }
    //    $addClient="INSERT INTO client SET
    //           firstName='$firstName',
    //            lastName='$lastName',
    //            address='$address',
    //            phoneNumber='$phoneNumber',
    //            emailAddress='$emailAddress';";

    //    $addUser="INSERT INTO users SET
    //            userName='$userName',
     //           password='$password';";


    if(@mysql_query($addClient)){
          echo "Thank you ".$firstName." your user name is: ".$userName."<br>";
          echo("<p>Client Added.</p>");
        }else{
          echo("<p>Error adding client: </p>".mysql_error()."</p>");
        }
?>