#Selecting parents name to identify as volunteer. 35 if ($parent eq "Father") 36 { 37 $sub_parent = "Mother"; 38 $sth = $dbh->prepare ("select Father from Roster where User = \'$user\'"); 39 $sth->execute (); 40 41 $name = $sth->fetchrow_array; 42 } #end if Father 43 else 44 { 45 $sub_parent = "Father"; 46 $sth = $dbh->prepare ("select Mother from Roster where User = \'$user\'"); 47 $sth->execute (); 48 49 $name = $sth->fetchrow_array; 50 } #end else Mother 51 52 if ($name eq ""){ 53 $sth = $dbh->prepare ("select $sub_parent from Roster where User = \'$user\'"); 54 $sth->execute (); 55 56 $name = $sth->fetchrow_array; 57 58 } #end chk for not parent if statement. 59 60 print $query->h1({-align=>'center'},"THANK YOU FOR SIGNING UP $name"); 61