/home/bjcompany/domains/benjabhorn.com/public_html/benjabhorn_group/news_detail.php

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"  "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<title>เบญจพรกรุ๊ป  Benjabhorn Group</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<link href="style.css" rel="stylesheet" type="text/css">


<style type="text/css">
<!--
body {
    background-image:url(images/bg-inside.jpg); background-position:top; background-repeat:repeat-x;
}
#apDiv1 {
    position:absolute;
    left:422px;
    top:136px;
    width:822px;
    height:310px;
    z-index:1;
}
#apDiv2 {
    position:absolute;
    left:130px;
    top:160px;
    width:1000px;
    height:50px;
    z-index:1;
}
-->
</style></head>


<body  leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<!--<div id="apDiv1">
<iframe src="slide-project/index.html" width="800" height="300" frameborder="0" scrolling="no"></iframe></div>
 -->
<center>
<?php include("header.php"); ?>

<script type="text/javascript" src="exteen/jquery.lightbox.js"></script>  
<link rel="stylesheet" type="text/css" href="exteen/jquery.lightbox.css" media="screen" />  
<script type="text/javascript">  
$(function() { 
    $('#gallery a').lightBox(); 
}); 
</script>   
<?php 
            $queryAct="SELECT * FROM tbl_act3_data WHERE id='".$_GET['NewsID']."'     ";
            $resultAct=mysql_query($queryAct);
            $act=mysql_fetch_assoc($resultAct);
            
        $queryClip="SELECT * FROM tbl_act3_video WHERE cateID=  '".$_GET['NewsID']."'   ORDER BY id ASC   ";
        $resultClip=mysql_query($queryClip);
            
            //$queryAct="SELECT a.*, b.category_name  FROM tbl_act3_data a  LEFT JOIN  tbl_act_category b ON a.cate_id=b.id  WHERE a.id NOT IN ('".$_GET['NewsID']."')     AND a.cate_id= '".$_GET['CateID']."'  ORDER BY a.id DESC LIMIT 0, 5";
            $queryAct="SELECT a.*, b.category_name  FROM tbl_act3_data a  LEFT JOIN  tbl_act_category b ON a.cate_id=b.id  WHERE  a.cate_id= '".$_GET['CateID']."' AND a.first_page='1'  ORDER BY a.id DESC LIMIT 0, 5";
                $resultAct=mysql_query($queryAct);
                
                
                
                
                
             //------------------------------------------------------SELECT DEFAULT CATEGORY        
              if($_GET['CateID']==''){ 
                 $query="SELECT * FROM  tbl_act_category  ORDER BY id  ASC  LIMIT 0, 1";
                 $resultCategory=mysql_query($query);    
                 $dataCategory=mysql_fetch_assoc($resultCategory);        
                      $_GET['CateID']=$dataCategory['id'];
             }
             //------------------------------------------------------SELECT CATEGORY
              $query="SELECT * FROM  tbl_act_category  ORDER BY id  ASC ";
                $resultCategory=mysql_query($query);

                
?>
<table width="1000" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td width="1000"  colspan="2" height="420"  align="left" valign="top"><iframe src="Slideshow2/slide/index_slide.php" width="994" height="430" scrolling="no" frameborder="0" style="background:transparent;"></iframe></td>
  </tr>
  <tr>
    <td colspan="2"  align="left" valign="top"><table width="100%" border="0">
 
  <tr>
    <td height="53" align="center">
        <?php $n=1; while($cate=mysql_fetch_assoc($resultCategory)){?>
        <a href="news.php?CateID=<?php echo $cate['id']?>" class="bt-news"><img src="images/icon_news.png" alt="" width="35" height="28" border="0" align="absmiddle" style="margin-left:-10px; margin-top:-10px;"/><?php echo $cate['category_name']?></a>
        <?php if($n > 4){ echo "<br>"; $n=0;}?>
        <?php $n++; }?>    </td>
    </tr>
  <tr>
    <td height="21" class="txt30"><hr size="2" noshade="noshade" /></td>
  </tr>
  <tr>
    <td height="53" class="txt30"><div id="showCategory">&nbsp;</div></td>
    </tr>
    </table>
    </td>
    </tr>
  <tr>
    <td width="64%" height="35" align="left" valign="top" class="txt30"><table width="95%" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td height="37" class="h-title border-top-bottom LR20">&raquo;&nbsp;<?php echo $act['topic']?>&nbsp;<?php $icon=" <img src='images/ico-4408.gif'  width='30' height='10' border='0'/>"; GetNewIcon($act['date_start'],$icon)?></td>
      </tr>
      <tr>
            <tr>
              <td class="LR20" >&nbsp;</td>
            </tr>
            <tr>
        <td class="LR20" ><?php echo $act['detail']?> </td>
      </tr>

        <td align="center">
          <div id="gallery">
                    <ul> 
        <table  border="0" align="center">
              <tr>
        <?php 
                       $query="SELECT * FROM tbl_act3_pic WHERE  model_data_id= '".$act['id']."' ORDER BY id ASC  ";
                    $resultIMG=mysql_query($query);
                                      $n=1; $col=4; 
                                          while($pix=mysql_fetch_assoc($resultIMG)){
                                            $n_width2=130;$n_height2=130;
                                            create_thub2($path_product."/",$pix['pic_name'],$n_width2,$n_height2);
                                      ?>
                <td>
                <li><a href="<?php echo $path_product.$pix['pic_name']?>"  title="">
                <img src="<?php echo $path_product_tempx.$pix['pic_name']?>" border="0" class="border"></a>                </li>                </td>
                <?php if($n==$col){ echo "</tr><tr>"; $n=0; } $n++;    } ?>
        </tr></table>
        </ul></div>        </td>
      </tr>
      <tr>
        <td height="71">
                    
                    <table width="95%" border="0" align="center">
        <tr>
          <?php
               $n=1;$col=2; $x=1;
            while($currentData=mysql_fetch_assoc($resultClip)){ 
   ?>
          <td><table width="190" border="0" cellspacing="2" cellpadding="0">
            <tr>
              <td width="200" align="center" valign="top"><p>
                <?php  if($currentData['youtubeCode']){ ?>
                <iframe width="350" height="300" src="http://www.youtube.com/embed/<?php echo $currentData['youtubeCode']?>" frameborder="0" allowfullscreen="allowfullscreen"></iframe>
                <?php }else if($currentData['fileName']){             
                           $info =  pathinfo($path_product."/".$currentData['fileName']);
                        $info[extension]=strtolower($info[extension]);
                        $width="350";$height="300";
                        
                         switch     ($info[extension]){
                              case "flv";
                                      include('showFlv.php');
                                    break;
                              case "swf";
                                      include('showSwf.php');                              
                                    break;
                             case "wmv";
                                      include('showWmv.php');                              
                                    break;
                             case "mp4";
                                      include('showMp4.php');                              
                                    break;                                    
                        }
                        $x++;
           }
           ?>
              </p></td>
            </tr>
            <tr>
              <td align="center"><a href="#"  title="ลบ <?php echo $currentData['Title']?>" onclick="deleteThisClip('<?php echo $currentData['id']?>','<?php echo $currentData['fileName']?>')"><?php echo $currentData['Title']?></a></td>
            </tr>
          </table></td>
          <?php if($n==$col){ echo "</tr><tr>"; $n=0;}?>
          <?php $n++;}?>
        </tr>
      </table>        </td>
      </tr>
      <tr>
        <td><p> ฝ่ายประชาสัมพันธ์<br />
          เบญจพรกรุ๊ป</p></td>
      </tr>
    </table></td>
    <td width="36%" height="35" valign="top"  align="center"><div align="left">
      <table width="100%" border="0">
        <tr>
          <td background="images/index/index_32-copy.jpg" height="64" ><div id="ShowRightTitle"></div></td>
        </tr>
      </table>
      <br>
    </div>
      
        <div align="center">
          <table width="91%" border="0" cellpadding="0" cellspacing="0">
           <?php while($act=mysql_fetch_assoc($resultAct)){ 
                    $cateName=$act['category_name'];
    ?>
            <tr>
              <td width="30%" valign="top"><?php $query="SELECT * FROM tbl_act3_pic WHERE model_data_id = '".$act['id']."'   LIMIT 0,1 ";
                            $resultPix=mysql_query($query);
                            $pix=mysql_fetch_assoc($resultPix);
                ?>
                    <img src="<?php echo $path_product_tempx.$pix['pic_name']?>" alt="news" hspace="5" vspace="5"  class="border"></td>
              <td width="70%" valign="top"><a href="news_detail.php?NewsID=<?php echo $act['id']?>&page=<?php echo $_GET['page']?>&CateID=<?php echo $_GET['CateID']?>"  id="menu"><strong><?php echo $act['topic']?></strong></a>&nbsp;<?php $icon=" <img src='images/ico-4408.gif'  width='30' height='10' border='0'/>"; GetNewIcon($act['date_start'],$icon)?></a>
                  <p><?php $act['detail']=strip_tags($act['detail'], '<*>');  echo substr($act['detail'],0,250);?></p></td>
            </tr>
            <tr>
              <td height="10" colspan="2" class="line"></td>
            </tr>
            <?php }?>
            
          </table>
        </div>        
        <p align="center">&nbsp;</p></td>
  </tr>
  <tr>
    <td colspan="2" align="right" valign="top"><map name="Map" id="Map2">
        <area shape="rect" coords="229,2,299,30" href="#" alt="" />
        <area shape="rect" coords="306,2,383,30" href="type.php" alt="" />
      </map></td>
    </tr>
  <tr>
    <td height="73" colspan="2" align="left" valign="bottom" ><a href="news.php?CateID=<?php echo $_GET['CateID']?>&page=<?php echo $_GET['page']?>">&laquo;&nbsp;&nbsp;กลับหน้าข่าวสารทั้งหมด</a></td>
  </tr>
  <tr>
    <td colspan="2" align="left" valign="top" class="txt30">&nbsp;</td>
  </tr>
</table>
</center>
<script language="javascript">
        document.getElementById('showCategory').innerHTML = '<p class="txt30"><?php echo $cateName?></p>';
        document.getElementById('ShowRightTitle').innerHTML = '<span class="CateName">&nbsp;&nbsp;<?php echo $cateName?></span>';
</script>
<?php include("footer.php"); ?>
</body>
</html>