<?
function ShowNewsPic($Show,$Limit,$Type){
$width = 110 ; //?COA!CeO˜AUโ
$height = 150 ; //?COAEU˜‘I˜AUโ
$tdwidth = 120 ; //?COA!CeO˜‘I˜ ƒสOAO˜aƒสeADaeI˜ Pixel
$border = 7 ; //‘1OLaEe1‘I˜AIoAUโ
$strlen = 80 ; //NO1C1IN!EAEOeaEL˜aƒสeAUโ
$TopicTable = "woman"; //ƒสOAO˜!OAaae˜O1a1!OAa!co?O๗OA
$TopicTable1 = "topic"; //ƒสOAO˜!OAaae˜O1a1!OAa!co?O๗OA

if(!$Type){ $WHERE = "WHERE type='Karaoke-Lounge'  AND imgname !='' ";}else{ $WHERE = "WHERE type = 'Karaoke-Lounge' AND imgname !='' ";};
include "config.in.php";
include "pu_split.php";  /* เริ่มนำตัวแบ่งหน้ามาใช้*/
$db = mysql_connect($host,$username,$password) or die (mysql_error());
$sql = "select * from $TopicTable  $WHERE order by id DESC limit 0,$Limit";
$result = mysql_db_query($dbname,$sql) or die (mysql_error());

echo "<table width='300' border='0' cellspacing='3' cellpadding='0' align='center'>";
$count=0;
while( $row = mysql_fetch_array($result))
{
if ($count==0) {
echo "<tr>";
}

   $detail = "$row[topic]";
   $no = "$row[idname]";
   $detail1 = "$row[name_karaoke]";
   $detail2 = "$row[birdmonth]";
   $detail3 = "$row[birdyear]";
   $detail4 = "$row[height]";
   $detail5 = "$row[weight]";
   $detail6 = "$row[chest]";
   $detail7 = "$row[waist]";
   $detail8 = "$row[buttocks]";
   $result = pu_query($dbname,$sql,5); //แสดง 5 ข้อมูล/หน้า

   
   $topic = strlen($detail1);
   if ( $topic > $strlen ) {
     $Topic = substr($detail1,0,$strlen) . "...";
   } else {
        $Topic = $detail1;
   };
   echo"<td valign=top width=$tdwidth>";
   echo"<table width='720' border='0'>";
   echo"<td>";
   echo"<td valign=top width=$tdwidth><LEFT><A HREF=\"mbdetail_woman.php?id=$row[id]\" target=\"_blank\"><img src=\"item_woman/$row[imgname]\" width=$width height=$height border=$border></A></LEFT</td>";
   echo"<td valign=top width='600'> <LEFT><b>–ผ‘O :</b><A HREF=\"mbdetail_woman.php?id=$row[id]\" target=\"_blank\">&nbsp; $detail</a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<b>No. &nbsp;</b>$no<br><b>“X–ผ :&nbsp;</b>$Topic<br><b>’aถ“๚ :</b>$detail2 ŒŽ $detail3 “๚<br><b>g’ท :&nbsp;</b>$detail4 &nbsp;&nbsp;<b>cm.</b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<b>‘ฬd :&nbsp;</b>$detail5 &nbsp;&nbsp;<b>kg.</b><br><b>ƒoƒXƒg:&nbsp;</b>$detail6 &nbsp;&nbsp;&nbsp;&nbsp;<b>ƒEƒGƒXƒg:&nbsp;</b>$detail7 &nbsp;&nbsp;&nbsp;&nbsp;<b>ƒqƒbƒv:&nbsp;</b>$detail8 </LEFT></td>";
 
    echo"</td>";
   echo"</table>";
   
   
$count++;
if (($count%$Show) == 0)
 { echo "</tr>"; $count=0; }
}
echo "</table>";
pu_pageloop("detail = $topic&no = $idname&detail1 = $name_karaoke&detail2 = $birdmonth&detail3 = $birdyear&detail4 = $height&detail5 = $weight&detail6 = $chest&detail7 = $waist&detail8 = $buttocks"); //ส่วนที่เพิ่ม*/
}

   
/************************************************************************************************/
function ShowLastTopic($Show){
$strlen = 50 ; //NO1C1IN!EAEOeaEL˜?O๗OA
$TopicTable = "topic"; //ƒสOAO˜!OAaae˜O1a1!OAa!co?O๗OA
include "config.in.php";
$db = mysql_connect($host,$username,$password) or die (mysql_error());
$sql = "select * from $TopicTable  order by id DESC limit 0,$Show";
$result = mysql_db_query($dbname,$sql) or die (mysql_error());

while( $row = mysql_fetch_array($result)){
#ENC‘eI!ADEUe AOCa!O1aEeƒสNLII!
   $detail = "$row[topic]";
   $topic = strlen($detail);
   if ( $topic > $strlen ) {
     $Topic = substr($detail,0,$strlen) . "...";
   } else {
     $Topic = $detail;
   };
echo"<LI><A HREF=\"mbdetail_woman.php?id=$row[id]\" target=\"_blank\"> $Topic</A></LI></td>";
}
} //No?N˜!iaNe1aEL˜AOA!OAAeOEOL
?>

ไฟล์ pu_split.php /*********************/

<?

 function pu_query($dbname,$sql,$ListPerPage=20)
 {
  global $page;
  global $totalpage;

  $result=mysql_db_query($dbname,$sql);
  if (empty($page)) $page=1;
  $num=mysql_num_rows($result);
  $rt = $num%$ListPerPage;
    
  //หาจำนวนหน้าทั้งหมด
  $totalpage = ($rt!=0) ? floor($num/$ListPerPage)+1 : floor($num/$ListPerPage);
  $goto = ($page-1)*$ListPerPage;

  $sql .= " LIMIT $goto,$ListPerPage";
  $result=mysql_db_query($dbname,$sql);

  return $result;
 }

 function pu_pageloop($option="",$align="left")
 {
  global $page;
  global $totalpage;

  // รูปแบบตัวแปร option คือ $option = "id=$c_id";
  // ถ้ามีหลายตัวแปรก็จะเป็น  $option = "id=$c_id&name=$myname&action=$action";

  echo "<table align=center width=100% border=0 bordercolor=black cellspacing=0 cellpadding=2>\n";
  echo "<tr><td align=$align>\n";
  echo "<font color=#686898>\n";

  // สร้าง link เพื่อไปหน้าก่อน-หน้าถัดไป
  echo "กำลังแสดงหน้าที่  ";
  if($page>1 && $page<=$totalpage) {
   $prevpage = $page-1;
   echo "<a href='".$_SERVER['PHP_SELF']."?page=$prevpage&$option' title='Back'><-</a>\n";
  }

  echo " <b>$page/$totalpage</b> ";

  if($page!=$totalpage) {
   $nextpage = $page+1;
   echo "<a href='".$_SERVER['PHP_SELF']."?page=$nextpage&$option' title='Next'>-></a>\n";
  }

  echo "</font>\n";
  echo "</td></tr>\n";
  echo "<tr><td align=$align>\n";

  // วนลูปแสดงเลขหน้าทั้งหมด แบบเป็นช่วงๆ ช่วงละ 10 หน้า
  $b=floor($page/10);
  $c=(($b*10));

  if($c>1) {
   $prevpage = $c-1;
   echo "<a href='".$_SERVER['PHP_SELF']."?page=$prevpage&$option' title='10 หน้าก่อนนี้'><<</a> \n";
  }
  else{
   echo "<<\n";
  }

  echo " <b>";
  
  for($i=$c; $i<$page ; $i++) {
   if($i>0)
   echo "<a href='".$_SERVER['PHP_SELF']."?page=$i&$option'>$i</a> \n";
  }

  echo "<font size=2 color=red>$page</font> \n";

  for($i=($page+1); $i<($c+10) ; $i++) {
   if($i<=$totalpage)
   echo "<a href='".$_SERVER['PHP_SELF']."?page=$i&$option'>$i</a> \n";
  }

  echo "</b> ";

  if($c>=0) {
   if(($c+10)<$totalpage){
    $nextpage = $c+10;
    echo "<a href='".$_SERVER['PHP_SELF']."?page=$nextpage&$option' title='10 หน้าถัดไป'>>></a> \n";
   }
   else
    echo ">>\n";
  }
  else{
   echo ">>\n";
  }
 
  echo "</td></tr>\n";
  echo "</table>\n";
 }// จบฟังก์ชั่น pu_split

?>