';
}// 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;
*/
}
?>
