connect(); //===取出省份名称=== $strQuery="select num,name from province where flag='Y' order by num asc"; $db->query($strQuery); while ($db->next_record()){ list ($this_num,$this_name)=$db->Record; $show_province_name[$this_num] = $this_name; }//===== if (is_int($id)) {die ("非法操作!");} //判断$id值是否合法。 ?>

   
='$minDate' "; } if (trim($pt)!="#" && trim($pt)!="") {$sqlConditions.="and pt='$pt' ";} if (trim($pct)!="#" && trim($pct)!="") {$sqlConditions.="and pct='$pct' ";} if (trim($info_type)!="#" && trim($info_type)!="") {$sqlConditions.="and info_type='$info_type' ";} if (trim($keywords)!="") {$sqlConditions.="and title like '%$keywords%' ";} if (trim($province)!="#" && trim($province)!="") {$sqlConditions.="and province='$province' ";} if (trim($city)!="#" && trim($city)!="") {$sqlConditions.="and city='$city' ";} if (trim($sqlConditions)!="") {$sqlConditions=substr($sqlConditions,3);} $sqlOrders=" order by id desc "; $url="$PHP_SELF?$oriVARS"; //=== //建立数据库连接 $db = new DB_sql; $db->connect(); //=== //返回第一条记录位置、总行数、当前页码和总页码 list($firstRow,$totleRows,$currentPage,$totalPages)= divpage($tablename,$sqlConditions,$totleRows,$pageSize,$goPage); //建立并执行查询语句 $strQuery="select $selcetFields from $tablename "; if (trim($sqlConditions)!=""){$strQuery.="where $sqlConditions ";} if (trim($sqlOrders)!=""){$strQuery.=" $sqlOrders";} $strQuery .=" limit $firstRow, $pageSize "; $db->query($strQuery); if ($db->num_rows()==0) {echo "Sorry,暂时符合条件的没有记录!"; die();} //=== ?>

符合条件的信息  共 next_record()){ list ($id,$m_id,$info_type,$pt,$pct,$title,$content,$validate,$company,$province,$city,$address,$code, $contact,$tel,$fax,$email,$flag,$reg_time)=$db->Record; ?>

>
 
    [ ]
   [>详细信息]