<?php
	require_once ("check_login.php");

	$ospageid = (int)$_GET["ospageid"];
	$page_category = $_GET["page_category"];

	$sql = "select * from otherspage where ospageid = ?";
	$parameters = array($ospageid);
	$row = bind_pdo($sql, $parameters, "selectone");

	$sort = $row{"sort"};

	// Delete db
	$sql = "update otherspage set deleted = ? WHERE ospageid=?";
	$parameters = array("1", $ospageid);
	bind_pdo($sql, $parameters);


	//update sorting
	$sql = "update otherspage set sort = sort-1 where sort > ?";
	$parameters = array($sort);
	bind_pdo($sql, $parameters);

	$dbh = null;

	header("Location: otherspage_index.php?page_category=$page_category&msg=Delete Successfully");

?>