Artist Pool
by Special Effect Supply
We constantly get requests for help, contacts and opportunities
from people all over the world. Use this page to find someone
with a skill or talent you're looking for, connect with someone
in your area with similar interests, or to find work or other
opportunities. We send people to this list everyday.
This list is for
individual artists who are regular customers of Special Effect
Supply Corp.
For information on how to get on this list please go to our Artist Submission Form
and fill out the required information.
";
echo "
";
while ($row = mysql_fetch_array($GetCountriesTopMenuResult, MYSQL_BOTH))
{
global $CountryDistinct;
$CountryDistinct = $row["CountryDistinct"];
echo "
$CountryDistinct | ";
}
echo "
";
}
global $GroupImageLinkCount;
$GroupImageLinkCount = 0;
global $PhotoGroupLink;
$GetCountries = "SELECT DISTINCT (Country) as CountryDistinct FROM `FX_ArtistPool` WHERE Active = 'Y'";
$GetCountriesResult = mysql_query($GetCountries)
or die ("Couldn't execute GetCountriesResult query because: " . mysql_error());
$GetCountriesResultCOUNT = mysql_num_rows($GetCountriesResult);
if($GetCountriesResultCOUNT <=0)
{
echo "No Countries found...";
}
else
{
//echo "
";
while ($row = mysql_fetch_array($GetCountriesResult, MYSQL_BOTH))
{
global $CountryDistinct;
$CountryDistinct = $row["CountryDistinct"];
// echo "$CountryDistinct ";
$GetArtistFromCountry = "SELECT *, DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(Birthdate, '%Y') - (DATE_FORMAT(NOW(), '00-%m-%d') < DATE_FORMAT(Birthdate, '00-%m-%d')) AS Age
FROM FX_ArtistPool
WHERE Country = '$CountryDistinct'
AND Active = 'Y'
ORDER BY State ASC, City ASC, CompanyName ASC";
$GetArtistFromCountryResult = mysql_query($GetArtistFromCountry)
or die ("Couldn't execute GetArtistFromCountryResult query because: " . mysql_error());
$GetArtistFromCountryResultCOUNT = mysql_num_rows($GetArtistFromCountryResult);
if($GetArtistFromCountryResultCOUNT <=0)
{
echo "No $CountryDistinct Artists found...";
}
else
{
echo "
Artists in $CountryDistinct
";
while ($row = mysql_fetch_array($GetArtistFromCountryResult, MYSQL_BOTH))
{
$PrimaryID = $row["PrimaryID"];
$CompanyName = $row["CompanyName"];
$Specialize = $row["Specialize"];
$Name = $row["Name"];
$SkillLevel = $row["SkillLevel"];
$Birthdate = $row["Birthdate"];
$Street = $row["Street"];
$City = $row["City"];
$State = $row["State"];
$Zip = $row["Zip"];
$Country = $row["Country"];
$Note = $row["Note"];
$URL = $row["URL"];
$GalleryLink = $row["GalleryLink"];
$Email = $row["Email"];
$Telephone = $row["Telephone"];
$Telephone2 = $row["Telephone2"];
$Fax = $row["Fax"];
$Photo1 = $row["Photo1"];
$Photo2 = $row["Photo2"];
$Photo3 = $row["Photo3"];
$Photo4 = $row["Photo4"];
$hearaboutus = $row["hearaboutus"];
$additionalcomments = $row["additionalcomments"];
$LastUpdate = $row["LastUpdate"];
$Active = $row["Active"];
$Age = $row["Age"];
//echo "";
echo "
";
echo "";
if($URL != '' && $CompanyName != '')
{
echo "$CompanyName
";
}
elseif ($CompanyName != '')
{
echo "$CompanyName
";
}
if($Specialize != '')
{
echo "$Specialize
";
}
if($Name != '')
{
echo "$Name
";
}
if($SkillLevel != '')
{
echo "Skill Level: $SkillLevel
";
}
if($Birthdate != '')
{
//echo "$Birthdate
";
if($Age > 150)
{
}
else
{
echo "Age: $Age
";
}
}
if($Street != '')
{
echo "$Street
";
}
if($City != '')
{
echo "$City, ";
}
if($State != '')
{
echo " $State";
}
if($Zip != '')
{
echo " $Zip";
}
if($Country != '')
{
echo " $Country
";
}
if($Note != '')
{
echo "$Note
";
}
if($URL != '')
{
echo "URL: $URL
";
}
if($GalleryLink != '')
{
echo "$GalleryLink
";
}
if($Email != '')
{
//echo "Email: $Email
";
$EmailReplacedAT = ReplaceATSignWithPicture($Email);
//echo "Email: $EmailReplacedAT 
";
echo "Email $Name
";
}
if($Telephone != '')
{
echo "Tel1: $Telephone
";
}
if($Telephone2 != '')
{
echo "Tel2: $Telephone2
";
}
if($Fax != '')
{
echo "Fax: $Fax
";
}
if($Photo1 != '' || $Photo2 != '' || $Photo3 != '' || $Photo4 != '')
{
//echo "\n\n";
$GroupImageLinkCount = ($GroupImageLinkCount + 1);
//echo "\n\n";
if($GroupImageLinkCount < 1 || $GroupImageLinkCount > 20)
{
$GroupImageLinkCount = 1;
}
$PhotoGroupLink = "group" . $GroupImageLinkCount . "";
echo "\n\n";
}
if($Photo1 != '')
{
//echo "[Photo 1]";
echo "\n[Photo 1]";
}
if($Photo2 != '')
{
//echo "[Photo 2]";
echo "\n[Photo 2]";
}
if($Photo3 != '')
{
//echo "[Photo 3]";
echo "\n[Photo 3]";
}
if($Photo4 != '')
{
//echo "[Photo 4]";
//echo "[Photo 4]";
echo "\n[Photo 4]";
}
//echo "FX ID: $PrimaryID
";
if($Photo1 != '')
{
echo "
FX ID: $PrimaryID
";
//echo "
";
}
else
{
echo "FX ID: $PrimaryID
";
//echo "
";
}
echo "
";
} //end while ($row = mysql_fetch_array($GetArtistFromCountryResult, MYSQL_BOTH))
echo "
";
//echo "";
} //end else
} //end of while GetCountriesResult
} //end of else for get distinct countries
?>