prepare("select * from `tbl_gallery` where `delete_flag` = 0 order by `id` desc limit ".$start.",".$per_page." ");
$gallery -> execute();
if($gallery -> rowCount() > 0){
while($galleryRows = $gallery -> fetch(PDO::FETCH_ASSOC)){
?>
query($sql1);
$number = $query->rowCount();
$total_page = (ceil($number / $per_page));
if($total_page>1){
for($i=1;$i<=$total_page;$i++){
if($i==$page) {
echo "$i";
}
else {
echo "".$i."";
}
}
}
?>