loop to enter values in table

[russthebarber]

I am trying to use a loop to enter values from several arrays into a mysql table. i am pretty sure that my syntax must be wrong here. i have also tried without using "SET" on every line. can anyone help?

 

for($index = 0; $index < $repeatTimes; $index++)
{

$sql2 = "UPDATE table SET weekday = '$weekDayPhpArr[$index]' 
AND SET monthday = '$monthDayPhpArr[$index]'
AND SET month = '$monthPhpArr[$index]'
AND SET year = '$yearPhpArr[$index]'
AND SET veranstaltung = '$veranstaltungPhpArr[$index]'
AND SET musik = '$musikPhpArr[$index]'
AND SET dj_id = '$djIdPhpArr[$index]'
AND SET dj_name = '$djNamePhpArr[$index]'
AND SET dj_info = '$djInfoPhpArr[$index]'
AND SET handy = '$djHandyPhpArr[$index]'
AND SET email = '$djEmailPhpArr[$index]'
AND SET geld = '$geldPhpArr[$index]'
AND SET gebucht = '$gebuchtPhpArr[$index]'
WHERE id = '$idPhpArr[$index]'"; 

$result2 = mysql_query($sql2);
}

[russthebarber]

I have this working now using commas instead of AND SET. Thanks anyway.