>
> #put values into an array
> my @abfrage = $sth->fetchrow_array;
>
> #prepare insert of values from the array in second database
>
> my $sth2 = $dbh->prepare("INSERT INTO board @abfrage");
I think you need to interate through the array and split into the fields of
your table
then you can use place holders to go thru your array and insert records.
something like:
my $sth2 = $dbh->prepare( "INSERT INTO board VALUES (?,?..)" )
or die "Cannot prepare SQL statements from $DBI::errstr\n";
foreach (@abfrage){
chomp;
($field, $field2 ....) = split( /,/ ); #whatever your field are
$sth->execute( ($field, $field2 .... );
}
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
