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;