INSERTING SEVERAL DATA IN A TABLE (SAME COLUMN)

[kingjjx]

how can you insert data from a form to a table under the same column name at once ?
EX. Table has columns for fname, lname ,mon, tues, wed
Form looks like this:
1.
Fname:____
Lname:___
Hrs worked on Mon:___
Hrs worked on Tues:___
Hrs worked on Wed:___
2.
Fname:____
Lname:___
Hrs worked on Mon:___
Hrs worked on Tues:___
Hrs worked on Wed:___

[SUBMIT]

PLEASE HELP ON HOW TO DO THIS KINDA OF OPERATION

 

[kingjjx]

i finally did this !!!
MY NEW PROBLEM IS --> I have have a dropdown list in my form page .. so far its not letting me add it to the databse.

how do i do this ??

thanks
-jon

 

[bboult10]

How did you manage your first problem? I would like to do the same thing - add multiple rows to a datadase at once.

Thanks
bboult10

 

[Guest_imported]

bbout10,

You have to do an SQL INSERT for each record. The only exception that I know of is when the INSERT statement uses a subquery to select several rows out of another table(s).

kingjjx,
Can you be more specific. Exactly what is happening or not happening?

 

[kingjjx]

sorry guys for not being specific but I already figured the solution. I just did a loop insert kinda thing.

What I wanted to do and am able to do now is insert 5 last names and 5 first names at the same time.

thanks