<?php require_once('Connections/BE2.php');

mysql_select_db($database_BE2, $BE2);
$id= isset($_GET['id'])?$_GET['id']:0 ;  
$id2=explode("-",$id);


$query_Rt2 = sprintf("SELECT a . * , b.fe3 as fe3a , c.fe3 as fe3b, d.fe3 as fe3c FROM tb4 AS a, tb5 AS b, tb5 AS c, tb5 AS d WHERE a.deck='Y' AND a.feid1 = b.fe0
AND a.feid2 = c.fe0 AND a.feid3 = d.fe0 AND cuid2='%s' AND a.de0='%s'",$_SESSION['cuid'],GetSQLValueString($id2[count($id2)-1], "int"));
echo "11111";
// if($_SERVER['REMOTE_ADDR']=='220.130.43.121'){ echo $query_Rt2; }

$Rt2 = mysql_query($query_Rt2, $BE2) or die(mysql_error());
$row_Rt2 = mysql_fetch_assoc($Rt2);
$totalRows_Rt2  = mysql_num_rows($Rt2); 
//echo $query_Rt2;
?>
<br> 
<?
 if($totalRows_Rt2>0){
  do { ?>
    <div class="panel panel-info">
    <div>
          <br> <h2> <?= $row_Rt2['de2']; ?></h2> 
       <div class="col-sm-3"><span class="titlefontR">旅遊天數分類 / </span></div>
       <div class="col-sm-9"><span class="titleL"><?= $row_Rt2['fe3a']; ?></span></div>
       <div style="clear:both;"></div>
       <div class="col-sm-3"><span class="titlefontR">旅遊地區分類 / </span></div>
       <div class="col-sm-9"><span class="titleL"><?= $row_Rt2['fe3b']; ?></span></div> 
       <div style="clear:both;"></div>
       <div class="col-sm-3"><span class="titlefontR">費用分類 / </span></div>
       <div class="col-sm-9"><span class="titleL"><?= $row_Rt2['fe3c']; ?></span></div> 
       <div style="clear:both;"></div>
    </div>
    <div class="panel-body"><?= nl2br($row_Rt2['de3']); ?></div>
      
    <? for($i=1;$i<5;$i++){
		$wfile='/www/bus104/shoppic/'.$_SESSION['cuid']."/".$row_Rt2['jpic']."_".$i.".jpg";
		if(file_exists($wfile)){
		?>
    
			 <div class="col-md-3 team-grid ">
             <div class="thumbnail">
               <img src="/shoppic/<? echo $_SESSION['cuid']."/".$row_Rt2['jpic']."_".$i.".jpg" ;?>"  class="img-responsive" alt="<?= $row_Rt2['de2'];?>" title="<?= $row_Rt2['de2'];?>" /> 
               </div>
             </div>
      <?     } 
	     } ?>          
			 <div class="clearfix"> </div>
   </div>  
    
   <?php } while ($row_Rt2 = mysql_fetch_assoc($Rt2)); 
 }
   ?> 


<?php
mysql_free_result($Rt2);
 
?>
