...
$sql = "SELECT * FROM `blog` ORDER BY id DESC LIMIT $start_limit, $end_limit";
if ($category_id != '')
{
$sql = "SELECT * FROM `blog` WHERE category_id = '$category_id' ORDER BY id DESC LIMIT $start_limit, $end_limit";
}
$list_blog = mysqli_query($con,$sql);
while ($blog = mysqli_fetch_assoc($list_blog))
{
?>
}
?>
$sql = "SELECT COUNT(1) AS total FROM blog";
if ($category_id != '')
{
$sql = "SELECT COUNT(1) AS total FROM blog WHERE category_id = '$category_id'";
}
$arrc = f(q($sql));
$total_pages = $arrc['total'];
$total_pages = ceil($total_pages / $end_limit);
if ($page == '')
{
$page = 1;
}
$prev_page = $page - 1;
$next_page = $page + 1;
?>
if ($total_pages != 0)
{
?>
}
else
{
?>