1 and id =".$sort;
$sql.= " order by intOrder asc";
$row = $conn->Execute($sql);
if(!$row->EOF){
$pId=StrHtml1($row->fields("pId"));
$x_name=StrHtml1($row->fields($langFirst."name"));
$en_name=StrHtml1($row->fields("en_name"));
$pageTitle=$x_name;
}
$row->Close();
?>
1 ";
$sql.= " order by intOrder asc";
$rs = $conn->Execute($sql);
if(!$rs->EOF){
//得到结果集的数据个数(开始！)
$mmm=1;//用于计数，
$arr=array();
$query=mysql_query($sql);
while($list = mysql_fetch_array($query,MYSQL_ASSOC)){
$arr[]=$list;
}
$num=count($arr);
//(结束！)
while(!$rs->EOF){
$name=StrHtml1($rs->fields($langFirst."name"));
$rs_id=$rs->fields("id");
$href="products.php?sort=".$rs_id;
?>
- class="current" style="border:none" >
MoveNext();
}
}
$rs->Close();
?>
1 ";
if($keyword) {
if($langFirst=='en_'){
$sql.=" and en_name like '%".$keyword."%'";
}else{
$sql.=" and name like '%".$keyword."%'";
}
}else{
$sql.="and pId = ".$sort;
}
$sql.= " order by intOrder desc";
// print_r($sql);
$Pager = new SimplePager($conn);
$Pager->setOption("pageSize" , $pageSize);
$rs = $Pager->PageExecute($sql);
$m=1;
if(!$rs->EOF){
while(!$rs->EOF){
$name=StrHtml1($rs->fields($langFirst.'name'));
$id=$rs->fields('id');
$smallpic=$rs->fields('smallPic');
$bigpic=$rs->fields('bigPic');
$href="product-view.php?pro_id=".$id;
?>
-
MoveNext();
}
}else{
echo "没有相关数据！";
}
$rs->Close();
?>
MoveNext();
}
}else{
echo "没有相关数据！";
}
$rs->Close();
?>