isTablet()){ $img_path='//artephant.com/images/art/195/'; $device='tablet'; }elseif($detect->isMobile()&&!$detect->isTablet()){ $img_path='//artephant.com/images/art/165/'; $device='phone'; }else{ $img_path='//artephant.com/images/art/300/'; $device='desktop'; } //include_once('/home/artephant/public_html/inc/load-artworks.php'); isset($_GET['image'])?$image=$_GET['image']:$image=''; if($image=='1'||$image==''){ $displayType = 'class="search-with art-page"'; $class='art-only'; }else{ $displayType = 'class="search-with text-page hidden"'; $class='text-only'; } include_once('/home/artephant/config.php'); $conn=mysqli_connect($hostname,$user,$pass,$dbase)or die(mysqli_connect_error()); isset($_GET['search'])&&preg_match('/[0-9]+/',$_GET['search'])?$search=mysqli_real_escape_string($conn,$_GET['search']):$search='0'; isset($_GET['style'])?$style=mysqli_real_escape_string($conn,$_GET['style']):$style=''; isset($_GET['letter'])?$letter=mysqli_real_escape_string($conn,$_GET['letter']):$letter=''; isset($_GET['sort'])?$sort=mysqli_real_escape_string($conn,$_GET['sort']):$sort=''; ?>

FEATURED ARTISTS

\n";?>
>
'; } ?>
0){ echo "
\n"; echo "
\n"; echo "

".strtoupper($alpha)."

\n"; echo "
\n"; while($row=mysqli_fetch_array($result)){ echo ' '; } // end while() echo '
'; }// end if($results>0 for this letter) }// END foreach(alpha) mysqli_close($con); ?>
='$year' AND artist_birth_year!='' AND artist_birth_year!='NA' AND (artist_death_year=''||artist_death_year='0')"; $query2.=" AND artist_birth_year >='$year' AND artist_birth_year!='' AND artist_birth_year!='NA' AND (artist_death_year=''||artist_death_year='0')"; } if($sort=='3'){ $query1.=" AND artist_birth_year >='$year' AND artist_birth_year!='' AND artist_birth_year!='NA' AND (artist_death_year=''||artist_death_year='0')"; $query2.=" AND artist_birth_year >='$year' AND artist_birth_year!='' AND artist_birth_year!='NA' AND (artist_death_year=''||artist_death_year='0')"; } if($letter!=''){ $query1.=" AND artist_last_name LIKE '$letter%'"; $query2.=" AND artist_last_name LIKE '$letter%'"; } if($style!=''){ $query1.=" AND movement='$style'"; $query2.=" AND movement='$style'"; } $radio_count_query='SELECT * FROM (('.$query1.') UNION ('.$query2.')) as t'; break; } $radio_count_query.=$group_by; $result=mysqli_query($conn,$radio_count_query)or die(mysqli_error($conn)); $thisCount=0; if(mysqli_num_rows($result)>0){ while($row=mysqli_fetch_array($result)){ $artist_id=$row['artist_id']; $thisCount++; } } mysqli_close($conn); echo $thisCount; } function getMovementCount($movement,$movement_count_query){ echo '0'; /* include('/home/artephant/config.php'); $conn=mysqli_connect($hostname,$user,$pass,$dbase)or die(mysqli_connect_error()); $style=mysqli_real_escape_string($conn,$style); if($style!='ALL'){ $style_count_query.=" AND style='$style'"; } $result=mysqli_query($conn,$style_count_query)or die(mysqli_error($conn)); while($row=mysqli_fetch_array($result)){ $thisCount=$row['count']; } mysqli_close($conn); echo $thisCount; */ } ?>