I have never done this before, and this is the first time I have encountered this situation
Here is my code that I created:
$query = mysql_query("INSERT INTO customerinfo (CustomerID, FirstName, LastName, PhoneNumber, PhoneNumber, PhoneNumber, Email, Symptoms) VALUES ('', '{$first}', '{$last}', {$codearea}, {$threedigit}, {$fourdigit}, '{$email}')", $connection);
As you can see, I have table that has 6 columns, which are:
- CustomerInfo
- FirstName
- LastName
- PhoneNumber
- Symptoms
Now, when a client fills out the form, it should insert it into the database. However, if you look at my insert statement, I listed PhoneNumber column 3 times because the form has 3 fields(code area, prefix, and line number) on the HTML page, and I want all three fields insert into the PhoneNumber column. How can I do this?
Thank you!