Help with creating an INSERT statement using MySQL

[brandonio21]

This is due to the placement of certain elements of your code. All you need to do is change this line of your code
[code2=vbnet]Dim dbQuery As String = ""[/code2]

To:

[code2=vbnet]Dim dbQuery As String = "INSERT INTO customer (accountNumber, nameLAST, nameFIRST, nameCOMPANY, addressSTREET, addressSTREET1, addressCITY, addressSTATE, addressZIPCODE, phone, fax, email) VALUES('" & TextBoxAccount.Text & "','" & TextBoxLastName.Text & "','" & TextBoxFirstName.Text & "','" & TextBoxCompanyName.Text & "','" & TextBoxAddress1.Text & "','" & TextBoxAddress2.Text & "','" & TextBoxCity.Text & "','" & ComboBoxState.SelectedItem & "','" & MaskedTextBoxZip.Text & "','" & MaskedTextBoxPhone.Text & "','" & MaskedTextBoxFax.Text & "','" & TextBoxEmail.Text & "')"[/code2]

Then, delete the line that previously contained that data (line 16 in the code box thing) And you should be good!