Beginner needs help with Array

[Anon]

I've looked through the past solutions regarding how to insert data from an array into a database (i'm using MySQL) but there are a few wrinkles in mine that I can't figure out conceptually. Here's my problem:

I'm taking data from a form and allowing people to select their Interests (ie: Hockey, running, etc.) - which is saved in an array. This data is to go into the Interests table (fields I1 through I7). How do I get each interests to tie back to a person's ID number? An how to I get the Interests array to insert into I1 to I7 (order doesn't matter).

Here's what i've conceptually sketched out so far, it'll need some fine tuning:

for ($InsertInterest=0; $InsertInterests=7; $InsertInterests++)
{
$query2=Insert into interests
(I1,I2,I3,I4,I5,I6,I7)
values
('$I[$InsertInterests])
where
(CID == clients.CID)
}

[Anon]

Assuming Interest[] is the name you use
within your html form, here is one, hopefully understandable, way to do it :

$sql = "INSERT INTO interests {I1,I2,I3,I4,I5,I6,I7)
VALUES ('$Interest[0]','$Interest[1]','$Interest[2]',
'$Interest[3]','$Interest[4]','$Interest[5]',
'$Interest[6]')
WHERE interests.CID = clients.CID";

Your structure is very wrong and it's suggested you read about control-structures
and arrays in the manual. It's okay though, it takes practice to make perfect 🙂

I believe this forum interupts white space formatting but the above should still
make sense.

[Anon]

It seems a brace found its way into the statement. The {I1 should be (I1 ... doh!