CUSTOMER_INFORMATION
--------------------
id (auto-incrementing sequence, not null)
first_name
last_name
address_1
address_2
city
state
country
postal_code
...etc...
####
$dbh = DBI->connect($dsn, $user, $pass,
{ RaiseError => 1, PrintError => 1, AutoCommit => 1 });
$sql = $dbh->prepare_cached('
INSERT INTO Customer_Information (
First_Name, Last_Name, Address_1, Address_2, City, State,
Postal_Code
) VALUES (
?, ?, ?, ?, ?, ?, ?);
');
$sql->execute($FName, $LName, $Address1, $Address2, $City, $State,
$PostalCode);
####
select max(id) from customer_information where first_name = $FName and last_name = $LName;