multi row dynamic drop down with multi column textfield to be populated onChange

[mrheart5000]

I am trying to create a dynamic dropdown menu list of emails(as pri key) that has 3 columns of data(firstname, lastname, phonenumber) from a table in MySQL that is the first step.

 

The next step, when a user selects an email  from the dropdown menu / list I would like the column or firstname, lastname and phonenumber fields to be populated from the table the dropdown date comes from.

 

The next which I think is a bit harder,  i want the above setup to come in multiple rows from a loop, say 4 rows at a time individualy so that the same thing can be done once and the 4 records sent to the dbase on one  submit event or operation.

 

Is there any help that any one can give or point me in the direction of, I have tried to search on Google but not found anything.

 

Many Thanks

 

Mr. Heart