delete_customer.php

<?php
    session_start(); //starts the session
    if($_SESSION['user']){ //checks if user is logged in
    }
    else {
       header("location:index.php"); //redirects if user is not logged in.
    }

    if($_SERVER['REQUEST_METHOD'] == "GET")
    {
       include 'connect.inc.php'; //Connect to database
       $id = $_GET['id'];
       $sql_query="DELETE FROM customer WHERE item_id='$id'";
      // $result1=mysql_query($sql_query1);
       //$result2=mysql_query($sql_query2);
      // $result3=mysql_query($sql_query3);
      // $result4=mysql_query($sql_query4);
       $sql = "UPDATE `indus_shop`.`item` SET `customer_id` = NULL WHERE `item`.`item_id` = '$id';";
       $result=mysql_query($sql_query);
       $result2=mysql_query($sql);
      // $result=mysql_query($sql_query);

       if(/*($result and $result2 and $result1 and $result3 and */$result2 and $result){
              header("location:customer.php");
        }
        else{
          echo mysql_error();
        }
    }
?>