if ($checksite eq $none) { $insertsqlstatement = 'INSERT INTO database.database('; $x=0; foreach (@dbcolumn) { $insertsqlstatement = $insertsqlstatement . "@dbcolumn[$x]"; # if ($x != $numelements ) { $insertsqlstatement = $insertsqlstatement . ","; } # else { $insertsqlstatement = $insertsqlstatement . ') VALUES ('; } # $x=$x+1; } # $x=0; foreach (@dbcolumn) { $insertsqlstatement = $insertsqlstatement . '\'' . "@splitarray[$x]" . '\''; $splitstatement = $splitstatement . '$' .@dbcolumn[$x] ; # if ($x != $numelements) { $insertsqlstatement = $insertsqlstatement . ','; $splitstatement = $splitstatement . ','; } # else { $insertsqlstatement = $insertsqlstatement .')'; } $x=$x+1; } }