When you build the string to execute on hte sever, you need to add in the variable values dynamically.
The string you are passing uses the actual variable names not their values.
try something like this.
mySQL = "Insert INTO Master(PatronEmail,AreaCode,PhoneNumber,RegistrationDate,ExpirationDate) VALUES ('" & e1 & "','" & area(counter) & "','" & phone(counter) & "','" & registerDate & "','" & expireDate) & "'"
However this assumes that they are all string values of some sort, numeric values will not require the single quotation mark around the value.
eg (" & e1 & ", instead of ('" & e1 & "',
if eq is a numeric value in the database.
You can Response.Write(mySQL ) to see what the command looks like that you are acutally sending to the Database server.
I suggest trying to write out the mySQL value now and then when you have made the chages so you can see the difference.
They say, best men are moulded out of faults,
And, for the most, become much more the better
For being a little bad.