'-1'){ //'%VIP會員網%' $showpage=1; if($act<>'-1'){ $showpage=2; } if($showpage==1){ mysql_select_db($database_BE2, $BE2); $query_Rt2 = sprintf("SELECT distinct(a.vid) ,a.vdoc ,a.vimg FROM video_master as a, youvideo as b WHERE a.vid=b.ykid AND b.yflag='Y' AND a.vflag='Y' AND a.vkid like '%s' AND a.vzone like '%s' order by a.vindex,a.vid,b.yindex",'%VIP會員網%', '%'.$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 = "SELECT a.*,b.mem_user2,b.mem_auto,b.mem_logo2,b.scode FROM travel as a left join member as b on a.tb0=b.adkind where a.tbc='廣告會員網' AND tb3='Y' order by a.tbindex" ; $Rt3 = mysql_query($query_Rt3, $BE2) or die(mysql_error()); $row_Rt3 = mysql_fetch_assoc($Rt3); $totalRows_Rt3 = mysql_num_rows($Rt3); } else{ mysql_select_db($database_BE2, $BE2); $query_Rt2 = sprintf("SELECT * FROM video_master as a , youvideo as b WHERE a.vdoc='%s' AND a.vid=b.ykid AND b.yflag='Y' AND a.vflag='Y' AND a.vkid like '%s' AND a.vzone like '%s' order by a.vindex,a.vid,b.yindex", $act,'%VIP會員網%', '%'.$co1.'%') ; $Rt2 = mysql_query($query_Rt2, $BE2) or die(mysql_error()); $row_Rt2 = mysql_fetch_assoc($Rt2); $totalRows_Rt2 = mysql_num_rows($Rt2); } } $title=""; $i=0; ?>

$row_Rt3['tb0']){ $title=$row_Rt3['tb0']; if($i>0){ echo ''; } if($row_Rt3['tbimg']==''){ $logo_image='tr_bg_'.sprintf("%07d",$row_Rt3['tb0']).'.png'; }else{ $logo_image=sprintf("%04d",$row_Rt3['tb0']).$row_Rt3['tbimg'].'.png'; } ?> ''){ ?>

" width="130" height="108" title=""> 8)?substr($row_Rt3['mem_user2'],0,8):$row_Rt3['mem_user2']; echo $s1."
".$row_Rt3['scode']?>