NOW() and userid in (%s)",$clientID); $result = mysql_query($query,$link) or die("查询异常中断2 : ".$query); $row = mysql_fetch_assoc($result); $total=$row['num']; $totalpage=ceil($total/11); $page=$_GET['page']; if ($page=='') $page=1; $query = sprintf("select * from `user_info` where ispromotion=1 and period >NOW() and userid in (%s) order by integral desc limit ".(($page-1)*11).",11",$clientID); //echo $query; $result = mysql_query($query,$link) or die("查询异常中断2 : ".$query); while($row = mysql_fetch_assoc($result)){ if($i % 2 ==0) $divid='l'; else $divid='r'; $xml = ROOT.'/2008/cache/client/'.$row['username'].'.xml'; if(!file_exists($xml)){ continue; } $doc = new DOMDocument(); $doc->load($xml); $rows = $doc->getElementsByTagName( "item" ); foreach($rows as $node){ $company = $node->getElementsByTagName($lang."_company" )->item(0)->nodeValue; if(empty($company)) $company = $node->getElementsByTagName( "en_company" )->item(0)->nodeValue; $phone = $node->getElementsByTagName($lang."_phone" )->item(0)->nodeValue; if(empty($phone)) $phone = $node->getElementsByTagName( "en_phone" )->item(0)->nodeValue; $email = $node->getElementsByTagName($lang."_email" )->item(0)->nodeValue; if(empty($email)) $email = $node->getElementsByTagName( "en_email" )->item(0)->nodeValue; $msn = $node->getElementsByTagName($lang."_msn" )->item(0)->nodeValue; if(empty($msn)) $msn = $node->getElementsByTagName( "en_msn" )->item(0)->nodeValue; $address = $node->getElementsByTagName($lang."_address" )->item(0)->nodeValue; if(empty($address)) $address = $node->getElementsByTagName( "en_address" )->item(0)->nodeValue; $url = $node->getElementsByTagName("url" )->item(0)->nodeValue; $url = trim($url); $Makes = $node->getElementsByTagName( "Makes" )->item(0)->nodeValue; $Part = $node->getElementsByTagName( "Part" )->item(0)->nodeValue; } $PC = getCityName($row['province'],$row['city']); $logo = 'http://yiparts.com/2008/pic/ClientLogo/small/'.$row['username'].'.gif'; $urlstr=$url; if(strpos($url,'http://')===false) $url='http://'.$url; if(!empty($company)){ $phone=preg_replace('/\s{2,}| /',' ',strip_tags($phone)); $phone=str_replace(' ','',$phone); $ClientList.='
'; $i++; } } //echo $totalpage.'|'.$page; if ($totalpage>1) { echo ''; } if ($ClientList!='') { echo $ClientList; } else { //echo '
1、暂时没有任何供应商销售此配件!
2、如果您销售此配件,而且您想让您公司的名称和联系方式出现在这里,请通过下面的联系方式与我们联系!
以下联系方式是宜配网的业务人员的联系方式!注意:我们不销售配件!
'; echo '
此产品暂时没有供应商,请点击这个链接发布求购信息! http://yiparts.com/Part/cn/n/'.numrotstr($item).'
'; } mysql_free_result($result); ?>