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); ?>
''){ ?>
" title="" />