$whereStr=" where v_recycled=0 and (v_name like '%$searchword%' or v_actor like '%$searchword%' or v_director like '%$searchword%' or v_publisharea like '%$searchword%' or v_publishyear like '%$searchword%' or v_letter='$searchword' or v_tags='$searchword' or v_nickname like '%$searchword%')";

break;

case 0:

$whereStr=" where v_recycled=0 and v_name like '%$searchword%'";

break;

case 1:

$whereStr=" where v_recycled=0 and v_actor like '%$searchword%'";

break;

case 2:

$whereStr=" where v_recycled=0 and v_publisharea like '%$searchword%'";

break;

case 3:

$whereStr=" where v_recycled=0 and v_publishyear like '%$searchword%'";

break;

case 4:

$whereStr=" where v_recycled=0 and v_letter='".strtoupper($searchword)."'";

break;

case 5:

$whereStr=" where v_recycled=0";

if(!empty($tid)) $whereStr.=" and (tid in (".getTypeId($tid).") or FIND_IN_SET('".$tid."',v_extratype)<>0)";

if($year=="more")

{

$publishyeartxt=sea_DATA."/admin/publishyear.txt";

$publishyear = array();

if(filesize($publishyeartxt)>0)

{

$publishyear = file($publishyeartxt);

}

$yearArray=$publishyear;

$yeartxt= implode(',',$yearArray);

$whereStr.=" and v_publishyear not in ($yeartxt)";

}

if(!empty($year) AND $year!="more")

{$whereStr.=" and v_publishyear='$year'";}

if($letter=="0-9")

{$whereStr.=" and v_letter in ('0','1','2','3','4','5','6','7','8','9')";}