Multiple Record Inserting??/

Hi, I have a form where i want to be able to add five items to a database at the same time, i know i have to create an array somehow to be able to insert all 5 records in one go.

How do i create the array?

on your form,...



your php part...



that may help a bit

maybe i should explain it better:
I have a form, in that form i have 5 seperate items and in each item are 3 text fields, i have to create 2 arrays. My Form:

WHAT I NEED.
1 array should be for the 5 items and
1 array should be for the 3 text fields in each item.
so its going to be a nested for loop i think, something maybe like


im just not sure home to put the whole thing together

yeah something like that would work

How do i get the form variables into the 2 arrays ?

by using "item1[]" in your form,...you are initializing the array,..such that when the form is processed,..item1[] looks like

item1[]
1 => this item
2 => second item


etc,..etc.....

then just use a nested for loop to parse through each set of arrays

hi, im really stupid, could you post the actual code for doing this, please.

Once you submit the page you need something like this




Then each of those variables will be what ever you entered in the pevious page,

They will loop though it untill the array as finished

Then if you want to insert that data into a database add the following code into the loop, after
<form>
ITEM 1
<input name="item[]" type="text">
<input name="price[]" type="text">
<input name="category[]" type="text">

ITEM 2
<input name="item[]" type="text">
<input name="price[]" type="text">
<input name="category[]" type="text">

ITEM 3
<input name="item[]" type="text">
<input name="price[]" type="text">
<input name="category[]" type="text">

ITEM 4
<input name="item[]" type="text">
<input name="price[]" type="text">
<input name="category[]" type="text">

ITEM 5
<input name="item[]" type="text">
<input name="price[]" type="text">
<input name="category[]" type="text">

<input type="submit" name="Submit" value="Insert">
</form>

Once you submit the page you need something like this




Then each of those variables will be what ever you entered in the pevious page,

They will loop though it untill the array as finished

Then if you want to insert that data into a database add the following code into the loop, after the variables have been set

mysql_query("insert into table values (0, $vItem, $vPrice, $vCategory)");

Ben is da man

Thanks Ben,
as Black Adder said, "I love you and want to have your baby!"