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

if ($_REQUEST["mode"] == "Edit") {
    $mode = "Edit";
    $mode2 = "EDIT";
    $mode1 = "Update";
    $id = $_REQUEST['id'];
    $rs_tblsite = mysql_query("select * from tbl_city where `id`='$id'");
    $array_tblsite = mysql_fetch_array($rs_tblsite);
  
    $city_name = $array_tblsite['city_name'];
    $state_id = $array_tblsite['state_id'];
    $Status = $array_tblsite['Status'];
    
} else {
    $mode = "Add";
    $mode2 = "ADD";
    $mode1 = "Add";
}
?>
<link href="mel.css" type=text/css rel=stylesheet>
<link href="sdmenu.css" type=text/css rel=stylesheet>

<?php 
if($_REQUEST["mode"] != "Edit"){
?>
<script type="text/javascript">

</script>
<?php } else { ?>
<script type="text/javascript">

</script>

<?php } ?>

<table width="94%" border="0" cellspacing="0" cellpadding="0">
    <tr> 
        <td><form action="write_city.php" method="post" enctype="multipart/form-data"  name="add_city_form"  onsubmit="">
                <fieldset>
                    <legend> City Manager
                        <?= $mode2 ?>
                        FORM</legend>
                    <table width="97%" border="0" cellspacing="2" cellpadding="0">
                        
                        <tr> 
                            <td height="26" class="general" required>State Name : </td>
                            <td height="26" > 
                                <select name="state_id"  class="textfield" id="state_id" required/>
                                <option value="">--Select--</option>
                                <?php 
                                 $restult = mysql_query("select * from tbl_states where status='Activate' ");
                                 while($row = mysql_fetch_assoc($restult)) { 
                                ?>
                                
                                <option value="<?php echo $row['id'];?>" <?php if($state_id ==$row['id']) { echo "selected";}?>><?php echo $row['state_name'];?></option>
                                 <?php } ?>
                                </select>
                            </td>
                        </tr>
                          
                        <tr> 
                            <td height="26" class="general" required>City Name : </td>
                            <td height="26" > 
                                <input name="city_name" type="text" class="textfield" id="city_name"  value="<?= $city_name; ?>" size="35" maxlength="100" required/>
                            </td>
                        </tr>
                        <tr> 
                            <td width="29%" height="26" class="general">Status :</td>
                            <td>
                            <select name="status"  class="textfield" id="status"/>
                            <OPTION value="Activate" <?php if($Status == "Activate") { echo "selected";}?>>Activate</OPTION>
                            <OPTION value="Deactivate" <?php if($Status == "Deactivate") { echo "selected";}?>>Deactivate</OPTION>
                            </select>
                            </td>
                        </tr>
                        
                        
                        <tr align="center"> 
                            <td height="26" colspan="2"><label for="label"> 
                                    <input type="hidden" name="id" value="<?= $_REQUEST['id'] ?>" />
                                    <input type="submit" name="Submit" value="  Save  " class="button" />
                                    &nbsp;&nbsp;&nbsp;&nbsp; 
                                    <input type="reset" name="Submit" value="Reset" class="button" />
                                    <input name="mode" type="hidden" id="mode" value="<?= $_REQUEST['mode'] ?>" />
                                </label></td>
                        </tr>
                    </table>
                </fieldset>
            </form></td>
    </tr>
</table>