<?php //
include_once("session.php");
include_once("settings.php");

foreach ($_REQUEST as $key => $value) {
    $$key = $value;
}
$state_id = $_POST['state_id'];
$city_name = $_POST['city_name'];
$status  =  $_POST['status'];   
$date = date("Y-m-d H:i:s");
$session_name = $_SESSION['username'];

//           EDIT code
if ($_REQUEST['mode'] == "Edit") {  

    $sql = "update tbl_city set state_id ='" . $state_id . "',city_name = '" . $city_name . "',status = '" . $status . "',createdOn = '" . $date . "',createdBy = '" . $session_name . "',updatedOn = '" . $date . "',updatedBy = '" . $session_name . "' where id = '" . $_POST['id'] . "'";

}   
else {

    $sql = "insert into tbl_city (state_id,city_name,status,createdOn,createdBy,updatedOn,updatedBy) VALUES ('$state_id','$city_name','$status','$date','$session_name','$date','$session_name')";
     
}
$result = mysql_query($sql) 
      
        or die(mysql_error());  
?>

<script>
    document.location = "city_list.php?page=listcity";
</script>