query($qVals11); $record_found = mysql_num_rows($result); $nrows = mysql_num_rows($result); // $row = $connector->fetchArray($result); print "

"; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; // used to call page in new window // VIEW"; for($j=0;$j<$nrows;$j++){ $row = $connector->fetchArray($result); $qVals99 = "SELECT * FROM oda WHERE OrgId=".$row["OrgId"]; // echo $qVals99; $result99 = $connector->query($qVals99); $nrows99 = mysql_num_rows($result99); if (empty($row["OrgParent"])){ $DisplayParent = "N/A"; } else{ $DisplayParent = $row["OrgParent"]; } $EditURL = "OrgDetails.php?ID=".$row["OrgId"]; // ---------------------------------------------------------- print ""; $theString = "'; print ""; } // END FOR print "

FUNCTION	"; print "Parent	"; print "Name	"; print "Club#	"; print "Type	"; print "URL	"; print "Mems
".$theString.""; // ---------------------------------------------------------- print "	" . $DisplayParent; print "	" . $row["OrgName"].""; print "	" . $row["OrgNumber"].""; print "	" . $row["OrgType"].""; print "	" . $row["OrgWebPage"].""; print "	" . $nrows99.""; print "

"; ?>