name; } else { $member = $member . " or tmp_image.countryID=$cntr "; $countryName = $countryName.", ".$objCountry->name; } $cntrList[$count-1]= $cntr; } } if ($count>0) $member = $member .")"; //end Country if(($lastName=$txtLastName) != "") { $member = $member . " $amp tmp_image.artistName like '%$txtLastName%' "; } if(($minimum=$txtMinPrice) != "") { $query = $query . " and tmp_image.price >=$txtMinPrice "; $amp = " and "; } if(($maximum=$txtMaxPrice) != "") { $query = $query . " $amp tmp_image.price <=$txtMaxPrice "; $amp = " and "; } $heightmin = $txtHgtMin; $heightmax = $txtHgtMax; $widthmin = $txtWdhMin; $widthmax = $txtWdhMax; $sizeType = $radSizeType; if(@$radSizeType=="inch") { if($txtHgtMin != "") $HgtMin1 = (float)$txtHgtMin * 2.5; if($txtHgtMax != "") $HgtMax1 = (float)$txtHgtMax * 2.5; if($txtWdhMin!="") $WdhMin1 = (float)$txtWdhMin * 2.5; if($txtWdhMax != "") $WdhMax1 = (float)$txtWdhMax * 2.5; if($txtHgtMin!= "" || $txtHgtMax!= "" || $txtWdhMin!= "" ||$txtwdhMax!= "") { $amp = "and (("; } if(($minHgt = $txtHgtMin)!= "") { $query = $query . " $amp tmp_image.imgHeight >=$minHgt "; $amp = " and "; } if(($maxHgt = $txtHgtMax)!="") { $query = $query . " $amp tmp_image.imgHeight <=$maxHgt "; $amp = " and "; } if(($minWdh = $txtWdhMin)!= "") { $query = $query . " $amp tmp_image.imgWidth >=$minWdh "; $amp = " and "; } if(($maxWdh = $txtWdhMax)!="") { $query = $query . " $amp tmp_image.imgWidth <=$maxWdh "; } if($maxWdh!= "" || $minWdh!= "" || $maxhgt!= "" || $minHgt!= "") { $amp = " and sizeType='in') Or ("; } if($HgtMin1 != "") { $query = $query . " $amp tmp_image.imgHeight >=$HgtMin1 "; $amp = " and "; } if($HgtMax1 !="") { $query = $query . " $amp tmp_image.imgHeight <=$HgtMax1 "; $amp = " and "; } if($WdhMin1 != "") { $query = $query . " $amp tmp_image.imgWidth >=$WdhMin1 "; $amp = " and "; } if($WdhMax1 !="") { $query = $query . " $amp tmp_image.imgWidth <=$WdhMax1 "; } if($WdhMax1 !="" || $WdhMin1 !="" || $HgtMax1 !="" || $HgtMin1 !="") { $amp = " and tmp_image.sizeType='cm'))"; $query = $query . " $amp"; $amp=""; } } if(@$radSizeType=="cm") { if($txtHgtMin != "") $HgtMin1 = (float)$txtHgtMin / 2.5; if($txtHgtMax != "") $HgtMax1 = (float)$txtHgtMax / 2.5; if($txtWdhMin!="") $WdhMin1 = (float)$txtWdhMin / 2.5; if($txtWdhMax != "") $WdhMax1 = (float)$txtWdhMax / 2.5; if($txtHgtMin!= "" || $txtHgtMax!= "" || $txtWdhMin!= "" ||$txtwdhMax!= "") { $amp = "and (("; } if(($minHgt = $txtHgtMin)!= "") { $query = $query . " $amp tmp_image.imgHeight >=$minHgt "; $amp = " and "; } if(($maxHgt = $txtHgtMax)!="") { $query = $query . " $amp tmp_image.imgHeight <=$maxHgt "; $amp = " and "; } if(($minWdh = $txtWdhMin)!= "") { $query = $query . " $amp tmp_image.imgWidth >=$minWdh "; $amp = " and "; } if(($maxWdh = $txtWdhMax)!="") { $query = $query . " $amp tmp_image.imgWidth <=$maxWdh "; $amp=""; } if($maxWdh!= "" || $minWdh!= "" || $maxhgt!= "" || $minHgt!= "") { $amp = " and sizeType='cm') Or ("; } if($HgtMin1 != "") { $query = $query . " $amp tmp_image.imgHeight >=$HgtMin1 "; $amp = " and "; } if($HgtMax1!="") { $query = $query . " $amp tmp_image.imgHeight <=$HgtMax1 "; $amp = " and "; } if($WdhMin1 != "") { $query = $query . " $amp tmp_image.imgWidth >=$WdhMin1 "; $amp = " and "; } if($WdhMax1!="") { $query = $query . " $amp tmp_image.imgWidth <=$WdhMax1 "; $amp=""; } if(($WdhMax1 !="" || $WdhMin1 !="" || $HgtMax1 !="" || $HgtMin1 !="") && (@$radSizeType=="cm")) { $amp = " and tmp_image.sizeType='in'))"; $query = $query . " $amp "; $amp = ""; } } //Style $count = 0; $ore = ""; $styleList[0]=""; for($i=0;$iexecute("select codeName from tblcodes where codeID=$style"); if ($count==1) { $query = $query . " and ( tmp_image.styleID =$style "; $amp = " and "; $ore = " or "; $styleName = $DB->Fields["codeName"]; } else { $query = $query . " $ore tmp_image.styleID =$style "; $styleName = $styleName .", ". $DB->Fields["codeName"]; } $styleList[$count-1]= $style; } } if ($count>0) $query = $query .")"; //end of style //Subject $count = 0; $ore = ""; $subjectList[0] =""; for($i=0;$iexecute("select codeName from tblcodes where codeID=$subject"); if($count==1) { $query = $query . " and (tmp_image.subjectID =$subject "; $amp = " and "; $ore = " or "; $subjectName = $DB->Fields["codeName"]; } else { $query = $query . " $ore tmp_image.subjectID =$subject "; $subjectName = $subjectName .", " . $DB->Fields["codeName"]; } $subjectList[$count-1] = $subject; } } if ($count>0) $query = $query .")"; //end subject //Medium $count = 0; $ore = ""; $mediumList[0] = ""; for($i=0;$iexecute("select codeName from tblcodes where codeID=$medium"); if($count==1) { $query = $query . " and (tmp_image.mediumID =$medium "; $amp = " and "; $mediumName = $DB->Fields["codeName"]; } else { $query = $query . " or tmp_image.mediumID =$medium "; $mediumName = $mediumName .", " .$DB->Fields["codeName"]; } $mediumList[$count-1] = $medium; } } if ($count>0) $query = $query .")"; //end Medium //Surface $count = 0; $ore = ""; $surfaceList[0] = ""; for($i=0;$iexecute("select codeName from tblcodes where codeID=$surface"); if($count==1) { $query = $query . " and (tmp_image.surfaceID =$surface "; $amp = " and "; $surfaceName = $DB->Fields["codeName"]; } else { $query = $query . " or tmp_image.surfaceID =$surface "; $surfaceName = $surfaceName .", ". $DB->Fields["codeName"]; } $surfaceList[$count-1] = $surface; } } if ($count>0) $query = $query .")"; //end surface if(($keyword=$txtKeywords) != "") { $query = $query . " and (tmp_image.imgDesc like '%$txtKeywords%' or tmp_image.imageName like '%$txtKeywords%' )"; $amp = " and "; } //Art type $count = 0; $ore = ""; $artList[0]=""; for($i=0;$iexecute("select codeName from tblcodes where codeID=$artType"); if ($count==1) { $query = $query . " and ( tmp_image.artTypeID =$artType "; $amp = " and "; $ore = " or "; $artTypeName = $DB->Fields["codeName"]; $artList[$count-1] = $artType; } else { $query = $query . " $ore tmp_image.artTypeID =$artType "; $artTypeName = $artTypeName. ", " . $DB->Fields["codeName"]; $artList[$count-1] = $artType; } } } if ($count>0) $query = $query .")"; //end of art type $validUserId = "0"; $DB = new Database; $DB->execute("select userid from tblmember where regStatus=1"); for($i=1;$i<=$DB->recordCount;$i++,$DB->moveNext()) $validUserId = $validUserId . "," . $DB->Fields[0]; $DB->close(); if($query=="" && $member=="") { $query = "select imgHeight,imgWidth,sizeType,tmp_image.sellable,tmp_image.imageID,tmp_image.userID,tmp_image.thumbNailURL,tmp_image.imageName,tmp_image.artistName,tmp_image.type,tmp_image.price,tblcodes.codeName from tmp_image left join tblcodes on tblcodes.codeID=tmp_image.artTypeID where tmp_image.userid in($validUserId) "; } elseif($member =="") { $query = "select imgHeight,imgWidth,sizeType,tmp_image.sellable,tmp_image.imageID,tmp_image.userID,tmp_image.thumbNailURL,tmp_image.imageName,tmp_image.price,tmp_image.artistName,tmp_image.type,tblcodes.codeName from tmp_image left join tblcodes on tblcodes.codeID=tmp_image.artTypeID where tmp_image.userid in($validUserId) " . $query ; } else { $query = "select imgHeight,imgWidth,sizeType,tmp_image.sellable,tmp_image.imageID,tmp_image.userID,tmp_image.thumbNailURL,tmp_image.imageName,tmp_image.price,tmp_image.artistName,tmp_image.type,tblcodes.codeName from tmp_image left join tblcodes on tblcodes.codeID=tmp_image.artTypeID where $member and tmp_image.userid in ($validUserId) " . $query ; } $query = $query . " and userID not in ($templateUsers) "; $sortField = @$radSort; $sortType = @$radSortType; if(@$radSort=="price") { $query = $query ." order by tmp_image.price "; if(@$radSortType=="desc") $query = $query . " desc"; } if(@$radSort=="artist") { $query = $query ." order by tmp_image.artistName "; if(@$radSortType=="desc") $query = $query . " desc"; } $objDbResult = new Database; //echo $query; $objDbResult->execute($query); if($objDbResult->recordCount <= 0) $msg = "No results found that match your criteria"; } ?> WorldImages.com - Navigating the world of art
recordCount > 0) // { ?>

recordCount?> image(s) matched your criteria...
"; ?> "; ?> "; ?> "; ?> "; ?> "; ?> "; ?> "; ?> "; ?> "; ?> "; ?>  "; else if (($count%3)==2) echo ""; ?>
Keywords Type Of Art Subject Style Medium Surface Artist Name Country Price Range Height Range Width Range   
recordCount > 0) { ?>
 

recordCount; //get the number of first record for the current page $firstRecord = (($num-1) * $numRecordsPerPage); //get the total number of pages $noOfPages = ceil($recordCount / $numRecordsPerPage); if ($noOfPages==0) $noOfPages = 1; $pagename = "advsearchresults.php"; if ($num==$noOfPages) $lastRecord = $recordCount - $firstRecord; else $lastRecord = $numRecordsPerPage; $objDbResult->move($firstRecord); //Paging code ends here --------------------------------------------------------- ?> moveNext(); } ?>
 
 
execute("select siteID,galleryname from tblmicrosite where userID=".$objDbResult->Fields["userID"]); $siteId = $DbSite->Fields["siteID"]."/"; $siteName = $DbSite->Fields["galleryname"]; ?>
Fields["artistName"] != "") {echo @$objDbResult->Fields["artistName"];} else {echo " ";} ?>
Fields['imageID']."')\">"."";?>
execute("select reason from tblmicrosite where userID=" . @$objDbResult->Fields["userID"]); /* if ((@$objDbResult->Fields["sellable"] == "1") && (@$DBEcomCheck->Fields[0]=="")) $sellable = "Available online & retail"; else $sellable = "Available online only"; */ ?>
Fields["imageName"]; ?>
Fields["sizeType"]; echo "".$objDbResult->Fields["imgWidth"]." x ".$objDbResult->Fields["imgHeight"]." ".$sztype.""; ?>
Fields["codeName"] != "") {echo @$objDbResult->Fields["codeName"];} else {echo " ";} ?>
Fields["price"] != "0") { echo "$". @$objDbResult->Fields["price"]; } else {echo " ";} ?>
 
execute("select memtype from tblmember where userID=".$objDbResult->Fields["userID"]); if ($Dbmemtype->Fields["memtype"] == "PRE" ) //--- if member is PREMIER then display the follwoing icon ---- { echo ""; } elseif ($Dbmemtype->Fields["memtype"] == "PLA" ) //--- if member is PLATINUM then display the follwoing icon ---- { echo ""; } elseif ($Dbmemtype->Fields["memtype"] == "PRI" ) //--- if member is PLATINUM then display the follwoing icon ---- { echo ""; } ?>

recordCount > 0) { ?>
 
   
 
"; } ?>
 
Minimum Maximum
  • Fill in as many or as few search criteria as you wish.
  • If you leave a field blank, the advanced search engine will ignore that field.
  • You can select more than one entry by keeping the control (Ctrl) key pressed while making your selections.
US$ Price Range
Height Range
Width Range
 
 Inches
Centimeters
Keywords
Artist Name
Surface
Medium
Subject
Type Of Art
Style
 Country of Origin
Sort by
 Price Artist Lowest to highest Highest to lowest