''){ mysql_select_db($database_BE2, $BE2); //$query_Rt2 = "SELECT * FROM video_master as a left join youvideo as b on a.vid=b.ykid AND b.yflag='Y' where a.vflag='Y' AND a.vkid='旅遊網' order by vindex" ; $query_Rt2 = sprintf("SELECT * FROM video_master as a left join youvideo as b on a.vid=b.ykid AND b.yflag='Y' where a.vflag='Y' AND a.vkid like '%s' AND a.vzone like '%s' order by a.vindex,a.vid,b.yindex" ,'%旅遊網%', '%'.$co1.'%') ; $Rt2 = mysql_query($query_Rt2, $BE2) or die(mysql_error()); $row_Rt2 = mysql_fetch_assoc($Rt2); $totalRows_Rt2 = mysql_num_rows($Rt2); mysql_select_db($database_BE2, $BE2); $query_Rt3 = sprintf("SELECT a.*,b.company_title,b.company_pic,b.mid FROM travel as a left join company as b on b.co_tb1=2 AND a.tb0=b.co_tb2 AND b.company_title<>'' AND b.co_tb3='%s' where a.tbc='旅遊網' AND a.tb3='Y' order by a.tbindex",$co1) ; //$query_Rt3 = sprintf("SELECT a.*,b.company_title,b.company_pic,b.mid FROM company_kinds as a left join company as b on a.kid=b.co_tb2 AND b.company_title<>'' AND b.co_tb3='%s' WHERE a.kflag='Y' order by a.kindex",$co1); //b.company_kind>1 AND $Rt3 = mysql_query($query_Rt3, $BE2) or die(mysql_error()); $row_Rt3 = mysql_fetch_assoc($Rt3); $totalRows_Rt3 = mysql_num_rows($Rt3); } $title=""; $i=0; ?>
$row_Rt2['vid']){ $vid=$row_Rt2['vid']; if($i>0){ echo ''; } $logo_image=sprintf("%04d",$row_Rt2['vid']).$row_Rt2['vimg'].'.png'; ?> ''){ ?>
''){ $a1=''; $a2= '' ;} $a1=''; $a2= '' ; echo $a1;?>
$row_Rt3['tb0']){ $title=$row_Rt3['tb0']; if($i>0){ echo ''; } ?> ''){ ?>
" title="" />