Ok, this problem is kind of difficult to explain, so please bear with me here. This is the situation - I have a table in a MySQL database that contains user information (user id, first name, last name, company, address, etc.). I'm creating a new page that will allow a select group of users (based on their company) to each select 1 benefit option in each of 6 different drop down boxes. Sounds simple enough, right?
I want to pull the first and last names of the users from the USER database, and then in turn pair them each with 6 combo boxes, and at the bottom, there will be one submit button for all the users. I've started by using a query to select the specific users, then a mysql_num_rows command. I used the num rows to assign a counter, and generate a for loop for each combo box (so essentially I end up with a different variable for each combo box, like for the first user the combo values would be Life1, Death1, Health1, Auto1, etc. and the second user's variables would be Life2, Death2, Health2, Auto2, and so on, and so forth.
My problem is pairing each row with the user name. I can echo the names out, but I want to insert the names, and the benefit selections into a new table, BENEFITS. I know this is really confusing, but if anyone has any suggestions or best practice ideas, I need all the help I can get.
Thanks!
