Forums

This topic is locked

I need help inserting multiple records into one da

Posted 25 Jun 2004 03:19:46
1
has voted
25 Jun 2004 03:19:46 nick Jewett posted:
I have a php form which asks the user to list numbers in a text field for birds they have sited from a list. I want to have each bird, which has been given a number, to be inserted as a separate record in the same table. So multiple inserts into one table. Or is it possible to have one insert button insert multiple forms on the same page?

Replies

Replied 25 Jun 2004 12:42:22
25 Jun 2004 12:42:22 Simon Martin replied:
I would use a command rather than an INSERT - that way you can say what bit of the form goes into which database. So you can insert data from 2 or more tables at once.
If you need to maintain a relationship check out George Petrov's InsertWithIdent

Sharing knowledge saves valuable time!

Simon

Reply to this topic