Adding multiple rows to MySQL db

[Anon]

I have an admin page where the client can add up to 10 products to a database. Each of these products represents a new row in the table. How do I add these multiple rows? Do I just repeat the INSERT command over and over for each variable, or is there an easier way? Thx!

[Anon]

You have to do one insert per row.
That is how databases work :-)

[Anon]

Yes, but you can create a loop to do the inserts. I have not done this in PHP, but I've done this numerous times in other database languages. Name your variables in a pattern like fieldA1, fieldA2, fieldB1,fieldB2, etc. etc.. Then, no matter if there are two rows or twenty two, feed that to the loop. Something like...

$rowltr = "A"
$fieldnum = "1"
$maxfields = 5
$maxrow = 10

while $rowltr < $maxrow
while $fieldnum < $maxfields {
build your sql statement here
$sql = "insert into table1 values ("...
field".$rowltr.$fieldnum.", "
}
** execute it here
$result = db_query($sql)
}

This obviously isn't complete, but it should set you on the right track.

• Gary

[Anon]

I will use both suggestions. Thanks again!

cw