|
We receive constant requests for information about schools that teach makeup or related arts on a professional level for film, TV and print.
This is the place, no need to go anywhere else.
Hosted by: Special Effect Supply Corp.
Film or TV Schools:
Film & TV Connection
An established entertainment industry school where students train for careers in the film, TV and video fields.
3-20-9-4F Ryusen Taitou
Tokyo Japan 110-0012
TEL 03-5808-3870 FAX 03-5808-3871
E-mail: sales robotsfx.com 
HomePage: http://www.robotsfx.com/
";
//echo "
Displaying results Eastern | Central | Western | Canada
";
if($GetAllSchoolsUSACOUNT <=0)
{
echo "No USA Schools found...";
}
else
{
while ($row = mysql_fetch_array($GetAllSchoolsUSAResult, MYSQL_BOTH))
{
$PrimaryID = $row["PrimaryID"];
$Specialized = $row["Specialized"];
$Name = $row["Name"];
$Street = $row["Street"];
$City = $row["City"];
$State = $row["State"];
$Zip = $row["Zip"];
$Country = $row["Country"];
$Note = $row["Note"];
$URL = $row["URL"];
$Email = $row["Email"];
$Telephone = $row["Telephone"];
$Fax = $row["Fax"];
$Photo1 = $row["Photo1"];
$Photo2 = $row["Photo2"];
$Photo3 = $row["Photo3"];
$Photo4 = $row["Photo4"];
$LastUpdate = $row["LastUpdate"];
$Active = $row["Active"];
echo "
";
if($URL != '')
{
echo "$Name
";
}
else
{
echo "$Name
";
}
if($Specialized != '')
{
echo "$Specialized
";
}
if($Street != '')
{
echo "$Street
";
}
if($City != '')
{
echo "$City";
}
if($State != '')
{
echo ", $State";
}
if($Zip != '')
{
echo " $Zip";
}
if($Country != '')
{
echo " $Country
";
}
if($Telephone != '')
{
echo "Tel: $Telephone
";
}
if($Fax != '')
{
echo "Fax: $Fax
";
}
if($Note != '')
{
echo "$Note
";
}
if($Email != '')
{
$EmailReplacedAT = ReplaceATSignWithPicture($Email);
echo "$EmailReplacedAT
";
//echo "$Email
";
}
if($URL != '')
{
echo "$URL
";
}
if($Photo1 != '')
{
echo "[Photograph 1]";
}
if($Photo2 != '')
{
echo "[Photograph 2]";
}
if($Photo3 != '')
{
echo "[Photograph 3]";
}
if($Photo4 != '')
{
echo "[Photograph 4]";
}
if($Photo1 != '')
{
echo "
FX ID: $PrimaryID
";
echo "
";
}
else
{
echo "FX ID: $PrimaryID
";
echo "
";
}
} //end while
} //end else
/*************************** end of USA SCHOOLS *****************************/
/*************************** Canada SCHOOLS *****************************/
$GetAllSchoolsCanada = "SELECT *
FROM FX_MUSchools
WHERE Active = 'Y'
AND Country = 'Canada'
ORDER BY Name ASC, Country ASC, State ASC, City ASC";
$GetAllSchoolsCanadaResult = mysql_query($GetAllSchoolsCanada)
or die ("Couldn't execute GetAllSchoolsCanada query because: " . mysql_error());
$GetAllSchoolsCanadaCOUNT = mysql_num_rows($GetAllSchoolsCanadaResult);
//ECHO "COUNT: $GetAllSchoolsCOUNT
";
//echo "
Displaying results Eastern | Central | Western | Canada
";
if($GetAllSchoolsCanadaCOUNT <=0)
{
echo "No Canadian Schools found...";
}
else
{
while ($row = mysql_fetch_array($GetAllSchoolsCanadaResult, MYSQL_BOTH))
{
$PrimaryID = $row["PrimaryID"];
$Specialized = $row["Specialized"];
$Name = $row["Name"];
$Street = $row["Street"];
$City = $row["City"];
$State = $row["State"];
$Zip = $row["Zip"];
$Country = $row["Country"];
$Note = $row["Note"];
$URL = $row["URL"];
$Email = $row["Email"];
$Telephone = $row["Telephone"];
$Fax = $row["Fax"];
$Photo1 = $row["Photo1"];
$Photo2 = $row["Photo2"];
$Photo3 = $row["Photo3"];
\ $Photo4 = $row["Photo4"];
$LastUpdate = $row["LastUpdate"];
$Active = $row["Active"];
echo "
";
if($URL != '')
{
echo "$Name
";
}
else
{
echo "$Name
";
}
if($Specialized != '')
{
echo "$Specialized
";
}
if($Street != '')
{
echo "$Street
";
}
if($City != '')
{
echo "$City";
}
if($State != '')
{
echo ", $State";
}
if($Zip != '')
{
echo " $Zip";
}
if($Country != '')
{
echo " $Country
";
}
if($Telephone != '')
{
echo "Tel: $Telephone
";
}
if($Fax != '')
{
echo "Fax: $Fax
";
}
if($Note != '')
{
echo "$Note
";
}
if($Email != '')
{
$EmailReplacedAT = ReplaceATSignWithPicture($Email);
echo "$EmailReplacedAT
";
//echo "$Email
";
}
if($URL != '')
{
echo "$URL
";
}
if($Photo1 != '')
{
echo "[Photograph 1]";
}
if($Photo2 != '')
{
echo "[Photograph 2]";
}
if($Photo3 != '')
{
echo "[Photograph 3]";
}
if($Photo4 != '')
{
echo "[Photograph 4]";
}
if($Photo1 != '')
{
echo "
FX ID: $PrimaryID
";
echo "
";
}
else
{
echo "FX ID: $PrimaryID
";
echo "
";
}
} //end while
} //end else
/*************************** end of Canada SCHOOLS *****************************/
/*************************** AllOthers SCHOOLS *****************************/
$GetAllSchoolsAllOthers = "SELECT *
FROM FX_MUSchools
WHERE Active = 'Y'
AND Country <> 'Canada'
AND Country <> 'USA'
ORDER BY Name ASC, Country ASC, State ASC, City ASC";
$GetAllSchoolsAllOthersResult = mysql_query($GetAllSchoolsAllOthers)
or die ("Couldn't execute GetAllSchoolsAllOthers query because: " . mysql_error());
$GetAllSchoolsAllOthersCOUNT = mysql_num_rows($GetAllSchoolsAllOthersResult);
//ECHO "COUNT: $GetAllSchoolsCOUNT
";
//echo "
Displaying results Eastern | Central | Western | AllOthers
";
if($GetAllSchoolsAllOthersCOUNT <=0)
{
echo "No Canadian Schools found...";
}
else
{
while ($row = mysql_fetch_array($GetAllSchoolsAllOthersResult, MYSQL_BOTH))
{
$PrimaryID = $row["PrimaryID"];
$Specialized = $row["Specialized"];
$Name = $row["Name"];
$Street = $row["Street"];
$City = $row["City"];
$State = $row["State"];
$Zip = $row["Zip"];
$Country = $row["Country"];
$Note = $row["Note"];
$URL = $row["URL"];
$Email = $row["Email"];
$Telephone = $row["Telephone"];
$Fax = $row["Fax"];
$Photo1 = $row["Photo1"];
$Photo2 = $row["Photo2"];
$Photo3 = $row["Photo3"];
\ $Photo4 = $row["Photo4"];
$LastUpdate = $row["LastUpdate"];
$Active = $row["Active"];
echo "
";
if($URL != '')
{
echo "$Name
";
}
else
{
echo "$Name
";
}
if($Specialized != '')
{
echo "$Specialized
";
}
if($Street != '')
{
echo "$Street
";
}
if($City != '')
{
echo "$City";
}
if($State != '')
{
echo ", $State";
}
if($Zip != '')
{
echo " $Zip";
}
if($Country != '')
{
echo " $Country
";
}
if($Telephone != '')
{
echo "Tel: $Telephone
";
}
if($Fax != '')
{
echo "Fax: $Fax
";
}
if($Note != '')
{
echo "$Note
";
}
if($Email != '')
{
$EmailReplacedAT = ReplaceATSignWithPicture($Email);
echo "$EmailReplacedAT
";
//echo "$Email
";
}
if($URL != '')
{
echo "$URL
";
}
if($Photo1 != '')
{
echo "[Photograph 1]";
}
if($Photo2 != '')
{
echo "[Photograph 2]";
}
if($Photo3 != '')
{
echo "[Photograph 3]";
}
if($Photo4 != '')
{
echo "[Photograph 4]";
}
if($Photo1 != '')
{
echo "
FX ID: $PrimaryID
";
echo "
";
}
else
{
echo "FX ID: $PrimaryID
";
echo "
";
}
} //end while
} //end else
/*************************** end of AllOthers SCHOOLS *****************************/
?>
NOTE: This page is the property of Special Effect Supply Corp. We reserve the right to include or exclude any listing without notice nor explanation. We do not have information regarding schools not listed here.
This page originally posted: 02/01/1999
This page last updated:
|
