include("myadmins/class/class.mysql.php"); include("myadmins/include/inc_page.php"); $objSelect= new mysql(); $objLimit= new mysql(); $objCount= new mysql(); $objSort= new mysql(); $perpage=5; if($_GET['page']!=""){$pageNum=$_GET['page'];}else{$pageNum=1;} $condition.=" news_status='Online'"; //----count page $numrows=$objCount->countRecord('tblnews','news_id',$condition); $arrPage=fncPage($numrows,$perpage,$pageNum); //-----query data $sort=$objSort->sortRecord('tblnews','news','news_topic',$condition); $limit= " Limit ".$arrPage[2].", ".$perpage.""; $result=$objLimit->limitRecord('tblnews',$condition,$limit,$sort); if($num=mysql_num_rows($result)){ $p=0; while($row=mysql_fetch_array($result)){ $news_id[$p]=$row['news_id']; $news_topic[$p]=$row['news_topic']; $p++; } } if($_GET['id']!=""){$id=$_GET['id'];}else{$id=$news_id[0];} //----query data default $condition=" news_id='".$id."'"; //---------------------------home photo------------------- $rsDataD=$objSelect->selectRecord('tblnews',$condition,''); $rowD=mysql_fetch_array($rsDataD); $link_like=$_SERVER['PHP_SELF'].'?id='.$id;//'http://www.thailandtourismcouncil.org/home.php'; $link_share=$_SERVER['PHP_SELF'].'?id='.$id;//'http://www.thailandtourismcouncil.org/home.php'; //-----query photo $condition=" news_id='".$id."'"; $condition.=" and photo_status='Online' "; $sort=$objSort->sortRecord('tblnews_photo','photo','photo_name_old',$condition); $limit=""; $resultP=$objLimit->limitRecord('tblnews_photo',$condition,$limit,$sort); if($numP=mysql_num_rows($resultP)){ $p=0; while($rowP=mysql_fetch_array($resultP)){ $photo_name[$p]=$rowP['photo_name_re']; $p++; } $facebook_image='imgadmins/news_small/'.$photo_name[0]; }else{ $facebook_image='images/icon/logo.png'; } ?>