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';
}
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['color'])?$color=mysqli_real_escape_string($conn,$_GET['color']):$color='';
isset($_GET['price'])?$price=mysqli_real_escape_string($conn,$_GET['price']):$price='';
isset($_GET['size'])?$size=mysqli_real_escape_string($conn,$_GET['size']):$size='';
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['subject'])?$subject=mysqli_real_escape_string($conn,$_GET['subject']):$subject='';
isset($_GET['letter'])?$letter=mysqli_real_escape_string($conn,$_GET['letter']):$letter='';
isset($_GET['sort'])?$sort=mysqli_real_escape_string($conn,$_GET['sort']):$sort='';
include_once('/home/artephant/config.php');
isset($_GET['category'])?$category=mysqli_real_escape_string($conn,$_GET['category']):$category='';
isset($_GET['artist'])?$artist_id=mysqli_real_escape_string($conn,$_GET['artist']):$artist_id='';
//$page_type='';
$styles_select=$style;
$styles_select=='all'||$styles_select==''?$styles_select='All Artwork Styles':$styles_select;
$galleries=array();
$query="SELECT DISTINCT user_id FROM calculator_c WHERE hide!='1' AND gallery_or_index='g'";
if($movement!=''&&$movement!='all'){
$query.=" AND movement='$movement'";
}
if($style!=''){
$query.=" AND style='$style'";
}
if($category!=''){
$query.=" AND category='$category'";
}
if($color!=''){
$query.=" AND colors='$color'";
}
if($letter!=''){
$query.=" AND artist_last_name LIKE '$letter%'";
}
if($size!=''){
switch($size){
case '0':
break;
case '1':
$query.=" AND ((depth=0 AND height>0 AND width>0 AND height*width <=450) OR (depth>0 AND height>0 AND width>0 AND height*width*depth <=450))";
break;
case '2':
$query.=" AND ((depth=0 AND height>0 AND width>0 AND height*width BETWEEN 451 AND 1200) OR (depth>0 AND height>0 AND width>0 AND height*width*depth BETWEEN 451 AND 1200))";
break;
case '3':
$query.=" AND ((depth=0 AND height>0 AND width>0 AND height*width BETWEEN 1201 AND 4608) OR (depth>0 AND height>0 AND width>0 AND height*width*depth BETWEEN 1201 AND 4608))";
break;
case '4':
$query.=" AND ((depth=0 AND height>0 AND width>0 AND height*width > 4608) OR (depth>0 AND height>0 AND width>0 AND height*width*depth >4608))";
break;
}
}
if($price!=''){
switch($price){
case 'ALL':
$query.="";
break;
case '0':
$query.=" AND pricing='price_request'";
break;
case "1-2000":
$query.=" AND sort_price <= 2000 AND sort_price>0";
break;
case "2000-5000":
$query.=" AND ((sort_price >= 2000 AND sort_price <= 5000) OR price_range='2,000-5,000')";
break;
case "5000-10000":
$query.=" AND ((sort_price >= 5000 AND sort_price <= 10000) OR price_range='5,000-10,000')";
break;
case "10000-15000":
$query.=" AND ((sort_price >= 10000 AND sort_price <= 15000) OR price_range='10,000-15,000')";
break;
case "15000-20000":
$query.=" AND ((sort_price >= 15000 AND sort_price <= 20000) OR price_range='15,000-20,000')";
break;
case "1-19999":
$query.=" AND ((sort_price <20000) OR price_range='Below-20,000')";
case "20000-30000":
$query.=" AND ((sort_price >= 20000 AND sort_price <= 30000) OR price_range='20,000-30,000')";
break;
case "1-29999":
$query.=" AND ((sort_price <30000) OR price_range='Below-30,000')";
break;
case "20000-40000":
$query.=" AND ((sort_price >= 20000 AND sort_price <= 40000) OR price_range='20,000-40,000')";
break;
case "1-39999":
$query.=" AND ((sort_price <40000) OR price_range='Below-40,000')";
break;
case "30000-40000":
$query.=" AND ((sort_price >= 30000 AND sort_price <= 40000) OR price_range='30,000-40,000')";
break;
case "30000-50000":
$query.=" AND ((sort_price >= 30000 AND sort_price <= 50000) OR price_range='30,000-50,000')";
break;
case "50001-100000000000":
$query.=" AND ((sort_price >50000) OR price_range='Above-50,000')";
break;
case "75001-100000000000":
$query.=" AND ((sort_price >75000) OR price_range='Above-75,000')";
break;
case "100001-100000000000":
$query.=" AND ((sort_price >100000) OR price_range='Above-100,000')";
break;
case "250001-100000000000":
$query.=" AND ((sort_price >250000) OR price_range='Above-250,000')";
break;
case "500001-100000000000":
$query.=" AND ((sort_price >500000) OR price_range='Above-500,000')";
break;
case "1000001-100000000000":
$query.=" AND ((sort_price > 1000000) OR price_range='Above-1,000,000')";
break;
case "SOLD":
$query.=" AND pricing='mark_sold'";
break;
case "DISPLAY":
$query.=" AND pricing='is_display'";
break;
}
}
$result=mysqli_query($conn,$query)or die(mysqli_error($conn));
if(mysqli_num_rows($result)>0){
while($row=mysqli_fetch_array($result)){
$galleries[]=$row['user_id'];
}
$gallery_checkboxes='';
}
if(count($galleries)>0){
foreach($galleries as $gallery){
$result=mysqli_query($conn,"SELECT establishment_name,gallery_type FROM users WHERE id='$gallery' AND frozen!='1'")or die(mysqli_error($conn));
if(mysqli_num_rows($result)>0){
while($row=mysqli_fetch_array($result)){
if($row['gallery_type']!='6'){
$gallery_checkboxes.='
';
}
}
}
}
}
$gallery_id=$user_id;
$followed_artists=array();
$followed_galleries=array();
$result=mysqli_query($conn,"SELECT artist_or_gallery,artist_id FROM alerts WHERE user_id='$user_id'")or die(mysqli_error($conn));
while($row=mysqli_fetch_array($result)){
if($row['artist_or_gallery']=='1'){
$followed_galleries[]=$row['artist_id'];
}else{
$followed_artists[]=$row['artist_id'];
}
}
$count_query="SELECT count(*) as count FROM calculator_c a JOIN users b on a.user_id=b.id";
$letter!=''?$count_query.=" WHERE a.hide=0 AND a.artist_last_name LIKE '$letter%'":$count_query;
switch($size){
case '0':
break;
case '1':
$count_query.=" AND ((a.depth=0 AND a.height>0 AND a.width>0 AND a.height*a.width <=450) OR (a.depth>0 AND a.height>0 AND a.width>0 AND a.height*a.width*a.depth <=450))";
break;
case '2':
$count_query.=" AND ((a.depth=0 AND a.height>0 AND a.width>0 AND a.height*a.width BETWEEN 451 AND 1200) OR (a.depth>0 AND a.height>0 AND a.width>0 AND a.height*a.width*a.depth BETWEEN 451 AND 1200))";
break;
case '3':
$count_query.=" AND ((a.depth=0 AND a.height>0 AND a.width>0 AND a.height*a.width BETWEEN 1201 AND 4608) OR (a.depth>0 AND a.height>0 AND a.width>0 AND a.height*a.width*a.depth BETWEEN 1201 AND 4608))";
break;
case '4':
$count_query.=" AND ((a.depth=0 AND a.height>0 AND a.width>0 AND a.height*a.width > 4608) OR (a.depth>0 AND a.height>0 AND a.width>0 AND a.height*a.width*a.depth >4608))";
break;
}
switch($price){
case 'ALL':
$count_query.="";
break;
case '0':
$count_query.=" AND a.pricing='price_request'";
break;
case "1-2000":
$count_query.=" AND a.sort_price <= 2000 AND a.sort_price>0";
break;
case "2000-5000":
$count_query.=" AND ((a.sort_price >= 2000 AND a.sort_price <= 5000) OR a.price_range='2,000-5,000')";
break;
case "5000-10000":
$count_query.=" AND ((a.sort_price >= 5000 AND a.sort_price <= 10000) OR a.price_range='5,000-10,000')";
break;
case "10000-15000":
$count_query.=" AND ((a.sort_price >= 10000 AND a.sort_price <= 15000) OR a.price_range='10,000-15,000')";
break;
case "15000-20000":
$count_query.=" AND ((a.sort_price >= 15000 AND a.sort_price <= 20000) OR a.price_range='15,000-20,000')";
break;
case "1-19999":
$count_query.=" AND ((a.sort_price <20000) OR a.price_range='Below-20,000')";
break;
case "20000-30000":
$count_query.=" AND ((a.sort_price >= 20000 AND a.sort_price <= 30000) OR a.price_range='20,000-30,000')";
break;
case "1-29999":
$count_query.=" AND ((a.sort_price <30000) OR a.price_range='Below-30,000')";
break;
case "20000-40000":
$count_query.=" AND ((a.sort_price >= 20000 AND a.sort_price <= 40000) OR a.price_range='20,000-40,000')";
break;
case "1-39999":
$count_query.=" AND ((a.sort_price <40000) OR a.price_range='Below-40,000')";
break;
case "30000-40000":
$price_count_query.=" AND ((a.sort_price >= 30000 AND a.sort_price <= 40000) OR a.price_range='30,000-40,000')";
break;
case "30000-50000":
$count_query.=" AND ((a.sort_price >= 30000 AND a.sort_price <= 50000) OR a.price_range='30,000-50,000')";
break;
case "50001-100000000000":
$count_query.=" AND ((a.sort_price >50000) OR a.price_range='Above-50,000')";
break;
case "75001-100000000000":
$count_query.=" AND ((a.sort_price >75000) OR a.price_range='Above-75,000')";
break;
case "100001-100000000000":
$count_query.=" AND ((a.sort_price >100000) OR a.price_range='Above-100,000')";
break;
case "250001-100000000000":
$count_query.=" AND ((a.sort_price >250000) OR a.price_range='Above-250,000')";
break;
case "500001-100000000000":
$count_query.=" AND ((a.sort_price >500000) OR a.price_range='Above-500,000')";
break;
case "1000001-100000000000":
$count_query.=" AND ((a.sort_price > 1000000) OR a.price_range='Above-1,000,000')";
break;
case "SOLD":
$count_query.=" AND a.pricing='mark_sold'";
break;
case "DISPLAY":
$count_query.=" AND a.pricing='is_display'";
break;
}
$category!=''?$count_query.=" AND a.category='$category'":$count_query;
$color!=''?$count_query.=" AND a.colors='$color'":$count_query;
$subject!=''?$count_query.=" AND a.style='$subject'":$count_query;
if($search!='12'&&$search!=''&&$search!='0'&&$search!='1'&&$search!='4'&&$search!='5'&&$search!='6'&&$search!='7'&&$search!='8'&&$search!='9'&&$search!='10'&&$search!='11'){
$count_query.=" AND a.user_id='$search'";
}
$price_count_query=$count_query;
$size_count_query=$count_query;
$style_count_query=$count_query;
$movement_count_query=$count_query;
$category_count_query=$count_query;
$color_count_query=$count_query;
// die($price_count_query);
// FROM calculator_c a JOIN users b on a.user_id=b.id AND a.colors='0'
?>
TO VIEW ANALYTICS
or
"Plus" or "Premium" Account Required To View Analytic Tools
ORIGINAL ".strtoupper(rtrim(trim($styles_select),'Art'))."ART FOR SALE";
}else{
echo "
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec eget faucibus magna. Nulla non ultricies leo. Sed metus ligula, sollicitudin in velit iaculis, eleifend condimentum turpis. Fusce eros lectus, dapibus et justo nec, pulvinar laoreet mi. Aliquam erat volutpat. Proin ex nisl, efficitur at tristique in, dictum in ante. Fusce libero mi, dictum sit amet neque non, faucibus accumsan est. Donec malesuada mauris ut hendrerit luctus.
Proin ex nisl, efficitur at tristique in, dictum in ante. Fusce libero mi, dictum sit amet neque non, faucibus accumsan est. Donec malesuada mauris ut hendrerit luctus.
More...
';
}// end if($results>0 for this letter)
}// END foreach(alpha)
mysqli_close($con);
?>
0 AND a.width>0 AND a.height*a.width <=450) OR (a.depth>0 AND a.height>0 AND a.width>0 AND a.height*a.width*a.depth <=450)) AND b.frozen!='1'";
break;
case '2':
$query.=" AND ((a.depth=0 AND a.height>0 AND a.width>0 AND a.height*a.width BETWEEN 451 AND 1200) OR (a.depth>0 AND a.height>0 AND a.width>0 AND a.height*a.width*a.depth BETWEEN 451 AND 1200)) AND b.frozen!='1'";
break;
case '3':
$query.=" AND ((a.depth=0 AND a.height>0 AND a.width>0 AND a.height*a.width BETWEEN 1201 AND 4608) OR (a.depth>0 AND a.height>0 AND a.width>0 AND a.height*a.width*a.depth BETWEEN 1201 AND 4608)) AND b.frozen!='1'";
break;
case '4':
$query.=" AND ((a.depth=0 AND a.height>0 AND a.width>0 AND a.height*a.width > 4608) OR (a.depth>0 AND a.height>0 AND a.width>0 AND a.height*a.width*a.depth >4608)) AND b.frozen!='1'";
break;
}
}
if($price!=''){
switch($price){
case 'ALL':
$query.="";
break;
case '0':
$query.=" AND a.pricing='price_request' AND b.frozen!='1'";
break;
case "1-2000":
$query.=" AND a.sort_price <= 2000 AND a.sort_price>0 AND b.frozen!='1'";
break;
case "2000-5000":
$query.=" AND ((a.sort_price >= 2000 AND a.sort_price <= 5000) OR a.price_range='2,000-5,000') AND b.frozen!='1'";
break;
case "5000-10000":
$query.=" AND ((a.sort_price >= 5000 AND a.sort_price <= 10000) OR a.price_range='5,000-10,000') AND b.frozen!='1'";
break;
case "10000-15000":
$query.=" AND ((a.sort_price >= 10000 AND a.sort_price <= 15000) OR a.price_range='10,000-15,000') AND b.frozen!='1'";
break;
case "15000-20000":
$query.=" AND ((a.sort_price >= 15000 AND a.sort_price <= 20000) OR a.price_range='15,000-20,000') AND b.frozen!='1'";
break;
case "1-19999":
$query.=" AND ((a.sort_price <20000) OR a.price_range='Below-20,000') AND b.frozen!='1'";
case "20000-30000":
$query.=" AND ((a.sort_price >= 20000 AND a.sort_price <= 30000) OR a.price_range='20,000-30,000') AND b.frozen!='1'";
break;
case "1-29999":
$query.=" AND ((a.sort_price <30000) OR a.price_range='Below-30,000') AND b.frozen!='1'";
break;
case "20000-40000":
$query.=" AND ((a.sort_price >= 20000 AND a.sort_price <= 40000) OR a.price_range='20,000-40,000') AND b.frozen!='1'";
break;
case "1-39999":
$query.=" AND ((a.sort_price <40000) OR a.price_range='Below-40,000') AND b.frozen!='1'";
break;
case "30000-40000":
$query.=" AND ((a.sort_price >= 30000 AND a.sort_price <= 40000) OR a.price_range='30,000-40,000') AND b.frozen!='1'";
break;
case "30000-50000":
$query.=" AND ((a.sort_price >= 30000 AND a.sort_price <= 50000) OR a.price_range='30,000-50,000') AND b.frozen!='1'";
break;
case "50001-100000000000":
$query.=" AND ((a.sort_price >50000) OR a.price_range='Above-50,000') AND b.frozen!='1'";
break;
case "75001-100000000000":
$query.=" AND ((a.sort_price >75000) OR a.price_range='Above-75,000') AND b.frozen!='1'";
break;
case "100001-100000000000":
$query.=" AND ((a.sort_price >100000) OR a.price_range='Above-100,000') AND b.frozen!='1'";
break;
case "250001-100000000000":
$query.=" AND ((a.sort_price >250000) OR a.price_range='Above-250,000') AND b.frozen!='1'";
break;
case "500001-100000000000":
$query.=" AND ((a.sort_price >500000) OR a.price_range='Above-500,000') AND b.frozen!='1'";
break;
case "1000001-100000000000":
$query.=" AND ((a.sort_price > 1000000) OR a.price_range='Above-1,000,000') AND b.frozen!='1'";
break;
case "SOLD":
$query.=" AND a.pricing='mark_sold' AND b.frozen!='1'";
break;
case "DISPLAY":
$query.=" AND a.pricing='is_display' AND b.frozen!='1'";
break;
}
}
$result=mysqli_query($conn,$query)or die(mysqli_error($conn));
$thisCount=0;
if(mysqli_num_rows($result)>0){
while($row=mysqli_fetch_array($result)){
$thisCount=$row['count'];
}
}
mysqli_close($conn);
return $thisCount;
}
function getPriceCount($price_var,$price_count_query){
include('/home/artephant/config.php');
$conn=mysqli_connect($hostname,$user,$pass,$dbase)or die(mysqli_connect_error());
switch($price_var){
case 'ALL':
$price_count_query.=" AND b.frozen!='1'";
//die($price_count_query);
break;
case '0':
$price_count_query.=" AND a.pricing='price_request' AND b.frozen!='1'";
break;
case "1-2000":
$price_count_query.=" AND a.sort_price <= 2000 AND a.sort_price>0 AND b.frozen!='1'";
break;
case "2000-5000":
$price_count_query.=" AND ((a.sort_price >= 2000 AND a.sort_price <= 5000) OR a.price_range='2,000-5,000') AND b.frozen!='1'";
break;
case "5000-10000":
$price_count_query.=" AND ((a.sort_price >= 5000 AND a.sort_price <= 10000) OR a.price_range='5,000-10,000') AND b.frozen!='1'";
break;
case "10000-15000":
$price_count_query.=" AND ((a.sort_price >= 10000 AND a.sort_price <= 15000) OR a.price_range='10,000-15,000') AND b.frozen!='1'";
break;
case "15000-20000":
$price_count_query.=" AND ((a.sort_price >= 15000 AND a.sort_price <= 20000) OR a.price_range='15,000-20,000') AND b.frozen!='1'";
break;
case "1-19999":
$price_count_query.=" AND ((a.sort_price <20000 AND a.sort_price>0) OR a.price_range='Below-20,000') AND b.frozen!='1'";
break;
case "20000-30000":
$price_count_query.=" AND ((a.sort_price >= 20000 AND a.sort_price <= 30000) OR a.price_range='20,000-30,000') AND b.frozen!='1'";
break;
case "1-29999":
$price_count_query.=" AND ((a.sort_price <30000 AND a.sort_price>0) OR a.price_range='Below-30,000') AND b.frozen!='1'";
break;
case "20000-40000":
$price_count_query.=" AND ((a.sort_price >= 20000 AND a.sort_price <= 40000) OR a.price_range='20,000-40,000') AND b.frozen!='1'";
break;
case "1-39999":
$price_count_query.=" AND ((a.sort_price < 40000 AND a.sort_price>0) OR a.price_range='Below-40,000') AND b.frozen!='1'";
break;
case "30000-40000":
$price_count_query.=" AND ((a.sort_price >= 30000 AND a.sort_price <= 40000) OR a.price_range='30,000-40,000') AND b.frozen!='1'";
break;
case "30000-50000":
$price_count_query.=" AND ((a.sort_price >= 30000 AND a.sort_price <= 50000) OR a.price_range='30,000-50,000') AND b.frozen!='1'";
break;
case "50001-100000000000":
$price_count_query.=" AND ((a.sort_price >50000) OR a.price_range='Above-50,000') AND b.frozen!='1'";
break;
case "75001-100000000000":
$price_count_query.=" AND ((a.sort_price >75000) OR a.price_range='Above-75,000') AND b.frozen!='1'";
break;
case "100001-100000000000":
$price_count_query.=" AND ((a.sort_price >100000) OR a.price_range='Above-100,000') AND b.frozen!='1'";
break;
case "250001-100000000000":
$price_count_query.=" AND ((a.sort_price >250000) OR a.price_range='Above-250,000') AND b.frozen!='1'";
break;
case "500001-100000000000":
$price_count_query.=" AND ((a.sort_price >500000) OR a.price_range='Above-500,000') AND b.frozen!='1'";
break;
case "1000001-100000000000":
$price_count_query.=" AND ((a.sort_price > 1000000) OR a.price_range='Above-1,000,000') AND b.frozen!='1'";
break;
case "SOLD":
$price_count_query.=" AND a.pricing='mark_sold' AND b.frozen!='1'";
break;
case "DISPLAY":
$price_count_query.=" AND a.pricing='is_display' AND b.frozen!='1'";
break;
}
$result=mysqli_query($conn,$price_count_query)or die(mysqli_error($conn));
while($row=mysqli_fetch_array($result)){
$thisCount=$row['count'];
}
mysqli_close($conn);
echo $thisCount;
}
function getSizeCount($size,$size_count_query){
include('/home/artephant/config.php');
$conn=mysqli_connect($hostname,$user,$pass,$dbase)or die(mysqli_connect_error());
switch($size){
case '0':
break;
case '1':
$size_count_query.=" AND ((a.depth=0 AND a.height>0 AND a.width>0 AND a.height*a.width <=450) OR (a.depth>0 AND a.height>0 AND a.width>0 AND a.height*a.width*a.depth <=450)) AND b.frozen!='1'";
break;
case '2':
$size_count_query.=" AND ((a.depth=0 AND a.height>0 AND a.width>0 AND a.height*a.width BETWEEN 451 AND 1200) OR (a.depth>0 AND a.height>0 AND a.width>0 AND a.height*a.width*a.depth BETWEEN 451 AND 1200)) AND b.frozen!='1'";
break;
case '3':
$size_count_query.=" AND ((a.depth=0 AND a.height>0 AND a.width>0 AND a.height*a.width BETWEEN 1201 AND 4608) OR (a.depth>0 AND a.height>0 AND a.width>0 AND a.height*a.width*a.depth BETWEEN 1201 AND 4608)) AND b.frozen!='1'";
break;
case '4':
$size_count_query.=" AND ((a.depth=0 AND a.height>0 AND a.width>0 AND a.height*a.width > 4608) OR (a.depth>0 AND a.height>0 AND a.width>0 AND a.height*a.width*a.depth >4608)) AND b.frozen!='1'";
break;
}
$result=mysqli_query($conn,$size_count_query)or die(mysqli_error($conn));
while($row=mysqli_fetch_array($result)){
$thisCount=$row['count'];
}
mysqli_close($conn);
echo $thisCount;
}
function getStyleCount($style,$style_count_query){
include('/home/artephant/config.php');
$conn=mysqli_connect($hostname,$user,$pass,$dbase)or die(mysqli_connect_error($conn));
$style=mysqli_real_escape_string($conn,$style);
if($style!='all'){
$style_count_query.=" AND a.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;
}
function getMovementCount($movement,$movement_count_query){
include('/home/artephant/config.php');
$conn=mysqli_connect($hostname,$user,$pass,$dbase)or die(mysqli_connect_error($conn));
$movement=mysqli_real_escape_string($conn,$movement);
if($movement!='all'){
$movement_count_query.=" AND a.movement='$movement' AND b.frozen!='1'";
}
$result=mysqli_query($conn,$movement_count_query)or die(mysqli_error($conn));
while($row=mysqli_fetch_array($result)){
$thisCount=$row['count'];
}
mysqli_close($conn);
echo $thisCount;
}
function getCategoryCount($category,$category_count_query){
include('/home/artephant/config.php');
$conn=mysqli_connect($hostname,$user,$pass,$dbase)or die(mysqli_connect_error());
if($category!='ALL'){
$category_count_query.=" AND category='$category' AND b.frozen!='1'";
}
$result=mysqli_query($conn,$category_count_query)or die(mysqli_error($conn));
while($row=mysqli_fetch_array($result)){
$thisCount=$row['count'];
}
mysqli_close($conn);
echo $thisCount;
}
function getColorCount($color,$color_count_query){
include('/home/artephant/config.php');
$conn=mysqli_connect($hostname,$user,$pass,$dbase)or die(mysqli_connect_error());
$color=mysqli_real_escape_string($conn,$color);
$color_count_query.=" AND a.colors='$color' AND b.frozen!='1'";
$result=mysqli_query($conn,$color_count_query)or die(mysqli_error($conn));
while($row=mysqli_fetch_array($result)){
$thisCount=$row['count'];
}
mysqli_close($conn);
echo $thisCount;
}
?>