查看文件: netstore.php

大小: 1.7 KB

类型: application/octet-stream

<?php require_once('../Connections/BE2.php'); ?>
 <? 
 
 
mysql_select_db($database_BE2, $BE2);
//$query_Rt3 = "SELECT a.*,b.* FROM company as a, company_kinds as b WHERE a.company_kind=b.kid AND a.company_kind >1 order by company_kind asc" ; sprintf(,$county)
$query_Rt3 = "SELECT a.*,b.coid,b.company_title,b.company_pic,b.mid FROM company_kinds as a left join company as b on a.kid= b.company_kind AND company_title<>'' WHERE a.kid between 2 AND 22 order by a.kid";

//$query_Rt3 = sprintf("SELECT a.*,b.* FROM company as a, company_kinds as b , address as c WHERE a.company_kind=b.kid AND a.company_kind >1 AND a.co_address=c.img_id AND c.county='%s' order by company_kind asc",$county) ;

$Rt3 = mysql_query($query_Rt3, $BE2) or die(mysql_error());
$row_Rt3 = mysql_fetch_assoc($Rt3);
$totalRows_Rt3 = mysql_num_rows($Rt3);
 
  ?>
 
  
<div class="container">  
 <div style="text-align:center;font-size:14px"></div>
<? 
$title=""; 
$i=0;
$cl=0;
do {

if($row_Rt3['company_title']<>''){
    ?>

<div class="col-md-2 col-xs-2 col-sm-2">
       <div class="thumbnail">
        <a href="/shopid/<?= str_replace('4','v',$row_Rt3['coid'])?>"><img name="" src="/shopmap/images/logo_<?= $row_Rt3['mid'].".".$row_Rt3['company_pic'] ?>"  title="<?= $row_Rt3['company_title'].$row_Rt3['kdoc']?>" /></a>
       </div>
            <div style="text-align:center;font-size:12px"><a href="/shop/<?= $row_Rt3['company_title']?>.html"><?=  $row_Rt3['company_title'] ;?></a></div> 
       </div>
         <? $cl++;  
	    if(( $cl% 6)==0 ){ ?> <div class="clearfix"> </div> <? }  ?>

<?   }?>
 
 
<? }  while ($row_Rt3 = mysql_fetch_assoc($Rt3));  ?>     
 
</div>

<? mysql_free_result($Rt3); ?>