กิจกรรมนักลงทุน
$strSQL = "SELECT * FROM activities ";
$objQuery= mysqli_query($conn,$strSQL);
$Num_Rows = mysqli_num_rows($objQuery);
$Per_Page = 3; // Per Page
$Page = $_GET["Page"];
if(!$_GET["Page"])
{
$Page=1;
}
$Prev_Page = $Page-1;
$Next_Page = $Page+1;
$Page_Start = (($Per_Page*$Page)-$Per_Page);
if($Num_Rows<=$Per_Page)
{
$Num_Pages =1;
}
else if(($Num_Rows % $Per_Page)==0)
{
$Num_Pages =($Num_Rows/$Per_Page) ;
}
else
{
$Num_Pages =($Num_Rows/$Per_Page)+1;
$Num_Pages = (int)$Num_Pages;
}
$strSQL .=" order by activities_order DESC LIMIT $Page_Start , $Per_Page";
$objQuery= mysqli_query($conn,$strSQL);
?>
while($objResult = mysqli_fetch_array($objQuery, MYSQLI_ASSOC))
{
?>
}
?>