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.


"; while ($row = mysql_fetch_array($GetCountriesTopMenuResult, MYSQL_BOTH)) { global $CountryDistinct; $CountryDistinct = $row["CountryDistinct"]; echo "$CountryDistinct | "; } } $GetCountries = "SELECT DISTINCT (Country) as CountryDistinct FROM `FX_ArtistPool`"; $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 USA 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 "

"; 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
"; } if($Telephone != '') { echo "Tel1: $Telephone
"; } if($Telephone2 != '') { echo "Tel2: $Telephone2
"; } if($Fax != '') { echo "Fax: $Fax
"; } if($Photo1 != '') { //echo "[Photo 1]"; echo "[Photo 1]"; } if($Photo2 != '') { //echo "[Photo 2]"; echo "[Photo 2]"; } if($Photo3 != '') { //echo "[Photo 3]"; echo "[Photo 3]"; } if($Photo4 != '') { //echo "[Photo 4]"; echo "[Photo 4]"; } //echo "FX ID: $PrimaryID
"; if($Photo1 != '') { echo "
FX ID: $PrimaryID
"; echo "
"; } else { echo "FX ID: $PrimaryID
"; echo "
"; } } //end while echo "

"; //echo "

"; } //end else } //end of while GetCountriesResult } //end of else for get distinct countries ?>

This page originally posted: 09/27/2007
This page last updated: