Makeup Schools
by Special Effect Supply
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.
Makeup Schools or Schools with Makeup Programs
";
$GetAllSchoolsUSA = "SELECT *
FROM FX_MUSchools
WHERE Active = 'Y'
AND Country = 'USA'
ORDER BY Name ASC, Country ASC, State ASC, City ASC";
$GetAllSchoolsUSAResult = mysql_query($GetAllSchoolsUSA)
or die ("Couldn't execute GetAllSchoolsUSA query because: " . mysql_error());
$GetAllSchoolsUSACOUNT = mysql_num_rows($GetAllSchoolsUSAResult);
//ECHO "COUNT: $GetAllSchoolsCOUNT
";
//echo "
Displaying results
Eastern |
Central |
Western |
Canada
";
if($GetAllSchoolsUSACOUNT <=0)
{
echo "No USA Schools found...";
}
else
{
global $GroupImageLinkCount;
$GroupImageLinkCount = 0;
global $PhotoGroupLink;
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 "
";
echo "
";
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 $Name
";
//echo "$Email
";
}
if($URL != '')
{
echo "$URL
";
}
if($Photo1 != '' || $Photo2 != '' || $Photo3 != '' || $Photo4 != '')
{
$GroupImageLinkCount = ($GroupImageLinkCount + 1);
if($GroupImageLinkCount < "1" || $GroupImageLinkCount > "20")
{
$GroupImageLinkCount = 1;
}
$PhotoGroupLink = "group" . $GroupImageLinkCount . "";
echo "\n\n";
}
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 "
";
}
echo "
";
} //end while
} //end else
/*************************** end of USA SCHOOLS *****************************/
/*************************** Canada SCHOOLS *****************************/
echo "
";
$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 "
";
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 $Name
";
//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 "
";
}
echo "
";
} //end while
} //end else
/*************************** end of Canada SCHOOLS *****************************/
/*************************** AllOthers SCHOOLS *****************************/
echo "
";
$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 "
";
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 $Name
";
//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 "
";
}
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.