include("../new_header.inc"); ?>
|
|
|||||||||
|
Organization Members Navigate by country: =$locountries?> $gaorg = mysql_query("SELECT * FROM Organizations, Countries WHERE Partnerflag = '10' AND Organizations.CountryID = Countries.CountryID AND Countries.RegionID = '$RegionID' ORDER BY CountryName,Name"); while ($org = mysql_fetch_array($gaorg)) { if (!strstr($ocountries,"|$org[CountryName]|")) { $ocountries .= "|$org[CountryName]|"; ?> =$org[CountryName]?> } ?> =stripslashes($org[Name])?> if ($org[City]) { ?>=$org[City]?>, } if ($org[StateProv]) { ?>=$org[StateProv]?>, } if ($org[CountryID]) { ?>=id2name(country,$org[CountryID])?> } ?> } tigdisconnect(); ?> } elseif ($membertype == "ind") { tigconnect("tig"); $gaind = mysql_query("SELECT DISTINCT CountryName FROM Users, tignetwork.consent, Countries WHERE Users.UserID = consent.UserID AND consent.SiteID = '3' AND Users.CountryID = Countries.CountryID AND Countries.RegionID = '$RegionID' ORDER BY CountryName,Name"); while ($ind = mysql_fetch_array($gaind)) { if (!strstr($indcountries,"|$ind[CountryName]|")) { $indcountries .= "|$ind[CountryName]|"; if ($licountries) { $licountries .= " | $ind[CountryName]"; } else { $licountries = "$ind[CountryName]"; } } } ?> Individual Members Navigate by country: =$licountries?> $gaind = mysql_query("SELECT * FROM Users, tignetwork.consent, Countries WHERE Users.UserID = consent.UserID AND consent.SiteID = '3' AND Users.CountryID = Countries.CountryID AND Countries.RegionID = '$RegionID' ORDER BY CountryName,Name"); while ($ind = mysql_fetch_array($gaind)) { if (!strstr($countries,"|$ind[CountryName]|")) { $countries .= "|$ind[CountryName]|"; ?> =$ind[CountryName]?> } ?> =getmemberinfo($ind[UserID],userid,Name)?> if ($ind[Title] || $ind[Organization]) { ?> if ($ind[Title]) { ?>=$ind[Title]?>, } if ($ind[Organization]) { ?>=$ind[Organization]?> } } ?> if ($ind[City]) { ?>=$ind[City]?>, } if ($ind[State]) { ?>=$ind[State]?>, } if ($ind[CountryID]) { ?>=id2name(country,$ind[CountryID])?> } ?> } tigdisconnect(); } if ($membertype) { ?> « back to main members listing } ?> |
||||||||