Dreamweaver One-to-Many Form with PHP and MySQL Problem

katslod

I'm using Dreamweaver CS3 to create a multi-table form. I'm not sure how to create it but what I want to do is use two tables, one called family, the other called children.

I'm auto incrementing the family ID in the family table each time a new family is entered. In the same form, I'd like to collect the family's children names, nicknames, age, and gender and store them in a table called children with the family ID as the primary key. I want to do this in one form and not have to move from one form to another and back.

Can anyone give me a quick way to do this simple thing in Dreamweaver? I know how to create recordsets, etc. but can a one-to-many relationship be created and used in the same form without having a separate page for the children? If so, can you give me some ideas on how to quickly accomplish this?

Thanks in advance; I'm a newbie to Dreamweaver, PHP, and MySQL, though a seasoned SQL programmer.

nemonoman

I don't know how to manage dreamweaver per se, but if you are an experienced SQL programmer new to PHP, here are some hints:

You can create forms that will submit an array of values:
<input type=text name=name[]><input type=text name=gender[]><BR>
<input type=text name=name[]><input type=text name=gender[]><BR>
<input type=text name=name[]><input type=text name=gender[]><BR>

Above would create three text inputs on your form.

After the form is submitted you can check the values thus:

$submittedNames=$POST['name'];
$submittedGenders=$POST['gender'];

Then use a for loop or similar. Assume you have created a new family and created a new family id '1234', you could say:

$familyid=1234;
$loopfor=count($submittedNames);
$i=0;
while($i<$loopfor){
$child=$submittedNames[$i];
$gender=$submittedGenders[$i];
mysql_query("INSERT INTO familyOffspring SET id=$familyid, offspring='$child', gender='$gender'");
$i++;
}