@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;
		}

##</code><code>##

@color_image=(a1.jpg, b1.jpg);
foreach $color_image(@color_image){
		$color_image=~s/^\s*//g;
		my $upcolor_qry="update colorimage_info set color_image='$color_image.JPG' where id='$newpid';
		my $upcolor_qy=$db->prepare($upcolor_qry);
		$upcolor_qy->execute;
	}	

##</code><code>##

pid cid color  color_image
8000 1  Blue   a1.jpg
8000 2  Silver a1.jpg