Multiple form fields in MySQL again

[Anon]

Hi. Is it possible to have a form with some fields that are being repeated for more than one entries, inserted in a MySQL db? For example the form has Name_fld, Address_fld, ID_fld for more than one persons, let's say 5 persons. Can i insert all these fields in MySQL with one form or do i need one form per person? I know that MySQL doesn't support transactions but i'm not sure whether this is a transaction 🙂

I posted this before and someone said it's possible. I'd appreciate a few more hints, tips, guidelines, full programs, anything 🙂

Thanks

John

[matto]

this is a php side issue:

you could make a form containing the inputs:

name 1: <input type=text name=Name_fld[]><br>
name 2: <input type=text name=Name_fld[]><br>

et cetera.

after submit, the receiving php script makes the data accessible in an "auto-enumerated" array:

name 1 is in $Name_fld[0]
name 2 is in $Name_fld[1]
etc.

that script can do many inserts in a loop:

for($i=0; $i<count($Name_fld); $i++)
{
$sql = "insert ... values(".$Name_fld[$i]."...)";
...
}

HTH!