my $sth2 = $dbh->prepare( "SELECT WORKERID,FAMID,CHILDID FROM p9315_2_partial_data WHERE WORKERID = '$pass'" );

$sth2->execute();

while ( $array_ref_partial = $sth2->fetchrow_arrayref ) {push @rows_partial, [ $array_ref_partial ]; #copy array contents to @row 


push (@partial_famids,  @$array_ref_partial[1] );