0) {
if($where=="") {
$where="(figure like '%$value%' or scene_type like '%$value%' or glyphic_content like '%$value%' or site like '%$value%' or position_site like '%$value%' or source like '%$value%' or source_details like '%$value%' or ceramic_type like '%$value%')";
} else {
$where=$where . " and (figure like '%$value%' or scene_type like '%$value%' or glyphic_content like '%$value%' or site like '%$value%' or position_site like '%$value%' or source like '%$value%' or source_details like '%$value%' or ceramic_type like '%$value%')"; }
} else {
if($where=="") {
$where="(figure like '%$value%' or scene_type like '%$value%' or glyphic_content like '%$value%' or site like '%$value%' or position_site like '%$value%' or source like '%$value%' or source_details like '%$value%' or ceramic_type like '%$value%')";
} else {
$where=$where . " and (figure like '%$value%' or scene_type like '%$value%' or glyphic_content like '%$value%' or site like '%$value%' or position_site like '%$value%' or source like '%$value%' or source_details like '%$value%' or ceramic_type like '%$value%')"; }
}//end if($srch_cnt>0)
}//end while
} else if(strstr($search,' or ')) {
$arr=split(' or ',$search);
while(list($key,$value) = each($arr)) {
if($srch_cnt>0) {
if($where=="") {
$where="(figure like '%$value%' or scene_type like '%$value%' or glyphic_content like '%$value%' or site like '%$value%' or position_site like '%$value%' or source like '%$value%' or source_details like '%$value%' or ceramic_type like '%$value%')";
} else {
$where=$where . " or (figure like '%$value%' or scene_type like '%$value%' or glyphic_content like '%$value%' or site like '%$value%' or position_site like '%$value%' or source like '%$value%' or source_details like '%$value%' or ceramic_type like '%$value%')"; }
} else {
if($where=="") {
$where="(figure like '%$value%' or scene_type like '%$value%' or glyphic_content like '%$value%' or site like '%$value%' or position_site like '%$value%' or source like '%$value%' or source_details like '%$value%' or ceramic_type like '%$value%')";
} else {
$where=$where . " or (figure like '%$value%' or scene_type like '%$value%' or glyphic_content like '%$value%' or site like '%$value%' or position_site like '%$value%' or source like '%$value%' or source_details like '%$value%' or ceramic_type like '%$value%')"; }
}//end if($srch_cnt>0) {
}//end while
}
}else {
$where="figure like '%$search%' or scene_type like '%$search%' or glyphic_content like '%$search%' or site like '%$search%' or position_site like '%$search%' or source like '%$search%' or source_details like '%$search%' or ceramic_type like '%$search%'";
}
###$where = addslashes($where);
//=echo $where;
#query db with new search term
$result = mysql_query("select * from werness_pabellons WHERE $where order by figure limit $rowstart,$display_number");
$result2 = mysql_query("select * from werness_pabellons WHERE $where order by figure");
$sql = "select * from werness_pabellons WHERE $where order by figure limit $rowstart,$display_number";
//echo $sql;
$result_cnt = @mysql_num_rows($result2);
$record_cnt = @mysql_num_rows($result);
##determine number of pages
if (!isset($num_pages))
{
if($result_cnt > $display_number)
{
$num_pages = ceil($result_cnt/$display_number);
} elseif($result_cnt > 0)
{ $num_pages = 1;
}
else
{
}
$start=0;
}
$a = $rowstart + ($display_number) ;
if ($a > $result_cnt) { $a = $result_cnt ; }
$b = $rowstart + 1 ;
echo '
FAMSI Research Materials
';
echo '
';
echo '';
echo '
';
echo '
Click on any image to view in high resolution.
';
echo '
';
echo "Click the checkboxes and the 'review selections' button to view images with captions in a printable format.
