[EvAn]

Hi!
Can anyone help me with this piece of code?

qty=request.form("qty")
qty=Split(qty,",")
choices = request.form("form")
choices = Split(choices, ",")

for each num in qty
if num=1 then
for each member in choices
num=1
sSQL = "INSERT into data (name, address, contact, user_name, form,qty) values ('" & name & "', '" & address & "', '" & contact & "', '" & user_name & "', '" & member & "', '" & num & "')"

connection.execute(sSQL)
next
else
for each member in choices
num=num
sSQL = "INSERT into data (form,qty) values ('" & member & "', '" & num & "')"

connection.execute(sSQL)
next
end if
next
__________________________________________________ _______________
thanx alot!

[Mikeirv]

What are you trying to do? What is your problem?

[EvAn]

which the codes that i post, i expect the data to be enter this way into the database...
____________________
| form | qty |
--------------------
| mem | num |
--------------------
| mem(1) | num(1) |
--------------------
| mem(2) | num(2) |
--------------------
| ... | ... |
--------------------

but it keep giving me

____________________
| form | qty |
--------------------
| mem | num |
--------------------
| mem | num(1) |
--------------------
| mem(1) | num |
--------------------
| mem(1) | num(1) |
--------------------
is it something wrong with my codes?
Please help me...
Thanks alot...