=10 and tm_trade_cost <=50";
break;
case 3:
$money_var="tm_trade_cost >50 and tm_trade_cost <=100";
break;
case 4:
$money_var="tm_trade_cost >100";
break;
default:
break;
}
if($tmname){
if(!$money && !$kind){
$tmname_var="tm_name="."'$tmname'";
}else{
$tmname_var="tm_name="."'$tmname'"." and ";
}
}
if($kind){
if(!$money){
$kind_var="tm_sort="."$kind";
}else{
$kind_var="tm_sort="."$kind"." and ";
}
}
if($tmname || $kind || $money){
$condit="where "."$tmname_var"."$kind_var"."$money_var";
}else{
$condit="";
}
$mysql="select * from trade_tm_info $condit order by id asc";
//echo $mysql;
$result=mysql_query($mysql);
$totle=mysql_num_rows($result);
$displaypg=25;
$url="result.php?money=$money&kind=$kind&tmname=$tmname"; //调用pageft()，每页显示10条信息（使用默认的20时，可以省略此参数），使用本页URL（默认，所以省略掉）。
pageft($totle,$displaypg,$url);
//现在产生的全局变量就派上用场了：
$query="select id,tm_name,tm_sort,tm_trade_cost,expire_date from trade_tm_info $condit order by id asc limit $firstcount,$displaypg";
$show=mysql_query($query);
$wenshu=5;
$wenzi1="ID";
$wenzi2="商标名称";
$wenzi3="国际分类";
$wenzi4="交易参考价值(单位:万元)";
$wenzi5="专用期限";
$endaddr="../content.php";
$tiao="id";
fengye($show,$wenshu,$wenzi1,$wenzi2,$wenzi3,$wenzi4,$wenzi5,$wenzi6,$endaddr,$tiao);
echo "
$pagenav
";
echo "
";
?>
