@color=(Blue, Silver); $newpid=8000; foreach $color(@color){ $color=~s/^\s*//g; my $incolor_qry="insert into colorimage_info(pid,color) values ('$newpid','$color')"; my $incolor_qy=$db->prepare($incolor_qry); $incolor_qy->execute; }