''){ 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='VIP會員網' 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" ,'%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); } $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 ''; } 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'; } ?> '') if(($row_Rt3['mem_logo2']<>'') &&( $ck) ){ ?>
" width="130" height="108" title=""> 8)?substr($row_Rt3['mem_user2'],0,8):$row_Rt3['mem_user2']; echo $s1."
".$row_Rt3['scode']?>