$page = $_GET['page'];
$select_type="select * from news where cat = 'variety' order by id desc";
$query_select=$mysqli->query($select_type);
$num_rows=mysqli_num_rows($query_select);
if($num_rows<1){
echo "
ไม่พบข้อมูลใด ๆ ในฐานข้อมูลค่ะ
";
}else{
$select="select * from news where cat = 'variety' order by id desc";
$q_ry = $mysqli->query($select);
$num_rows=mysqli_num_rows($q_ry);
$pagesize=6;
$rt=$num_rows%$pagesize;
if($rt!=0)
{
$totalpage=floor($num_rows/$pagesize)+1;
}
else
{
$totalpage=floor($num_rows/$pagesize);
$toppic_id=1;
}
if(empty($page))
{
$page=1;
}
mysqli_free_result($q_ry);
//$goto=($page-1)*$pagesize;
$goto = 4;
$sql_select_mem="Select * From news where cat = 'variety' order by read1 desc limit $goto,$pagesize";
$fect=$mysqli->query($sql_select_mem);
if(!$fect)
{
("ติดต่อฐานข้อมูลไม่ได้".mysql_error());
exit;
}
$bgcount=0;
while($rows=mysqli_fetch_array($fect))
{
$idnews =$rows['id'];
$topic_news =$rows['topic'];
$bgcount=$bgcount+1;
$bgmod=$bgcount%2;
if($bgmod==0){
$bgcolor="#EDE5CB";
}else{
$bgcolor="#CED2C2";
}
$topic_shownews = mb_substr($topic_news,0,40,'UTF-8');
?>