$page = "project-details";
include "header.php";
if(is_numeric($_REQUEST['project'])){
$project_id = $_REQUEST['project'];
}else{
$project_id = 1;
}
$pr_details = mysqli_query($con,"select * from projects where id =".$project_id);
$pr_detail = mysqli_fetch_array($pr_details);
$catt = mysqli_query($con, "select * from categories where id=".$pr_detail['category_id']);
$cat = mysqli_fetch_array($catt);
$page_name=$pr_detail['titr'];
//var_dump($pr_detail['pic1']);
?>
$photogallery=mysqli_query($con, "select * from photogallery where property_id=".$pr_detail['id']);
$i=1;
$j=1;
while($gall = mysqli_fetch_array($photogallery)) {
if($i%3==0){
$j=1;
?>
} ?>
$i++;
$j++;
if($j>2 && $i%3!=0){
$j=1;
?>
}
}
?>
var_dump($pr_detail['ord']);
$ord_proj = mysqli_query($con, "select max(ord) as max_ord_proj, min(ord) as min_ord_proj from projects");
$ord_proj = mysqli_fetch_assoc($ord_proj);
$next_proj_ord = $pr_detail['ord'] == $ord_proj['max_ord_proj'] ? $ord_proj['min_ord_proj'] : $pr_detail['ord'] + 1;
var_dump($next_proj_ord);
$next_project = mysqli_query($con,"select * from projects where ord=".$next_proj_ord);
$next_project = mysqli_fetch_assoc($next_project);
$catt = mysqli_query($con, "select * from categories where id=".$next_project['category_id']);
$cat = mysqli_fetch_array($catt);
?>