Forums

This topic is locked

Inserting Multiple Rows into the same table

Posted 24 Jul 2001 22:43:15
1
has voted
24 Jul 2001 22:43:15 I Mahomed posted:
Hi,

Ok heres the deal, i have a form with multiple text boxes (value is unknown as they are created dynamicly using a repear reigon) i wanna insert all text boxes into the same table but diffrent rows
e.g
Text Box1 Inserts into Field 1
Text Box2 Inserts into Field 2
Text Box3 Inserts into Field 1
Text Box 4 Inserts into Field 2 and so on...

anyone got an idea on how to do this?
Ultradev wont let you run more then 1 insert query.

thanx

Replies

Replied 24 Jul 2001 23:42:04
24 Jul 2001 23:42:04 Bruno Mairlot replied:
You'll have to do it by hand <img src=../images/dmxzone/forum/icon_smile_sad.gif border=0 align=middle>

You should name your input text following a counter like :

input name="text1"
input name="text2"

Then in the insert query, you'll get the different value then create a query and execute it.

Replied 25 Jul 2001 01:09:39
25 Jul 2001 01:09:39 Waldo Smeets replied:
I think charon.co.uk has an example

Waldo Smeets - www.UDzone.com Webmaster
------------------------------------------
www.UDzone.com : A dynamic Dreamweaver,
Ultradev and Fireworks site for developers
by developers.
------------------------------------------

Reply to this topic