<?php include("../../include/dbconnect.php");?>
<title>Company Edit page</title>
<body  background="../../images/fibermat.gif">
<center>
<table cellpadding=0 cellspacing=4 width=590>
<tr>
<td style="padding:3px;" colspan=2 background="../../images/g11line21.gif"><font  face="Arial, Helvetica, sans-serif"><b>Edit Company Details  </b></font></td>
</tr><tr valign="top"><td colspan=2>
<font >&nbsp;</font>
</td>
</tr>
</table>
<table border=0 cellpadding=3 cellspacing=4 width="590">
<form method="POST" action="update.php">

<?php

$result=mysqli_fetch_array(mysqli_query($conn,"select distinct record,compcode,name,address1,address2,city,state,country,pin,mobile,telno,fax,email,contact,tin,cst,cenvat_regno,servicetax_regno,ssi_no,account_year,description,cenvat_starts from company  where record = '$record'")) or die(mysqli_error());

?>
<input type="hidden"  name="record1" value = <?php echo($record);?>></td></tr>

<tr><td><font  face="Arial, Helvetica, sans-serif"><b>Company Code</b></font></td><td>           
 <input  type="text" onKeyPress="return event.keyCode!=13"     onKeyPress="return event.keyCode!=13"   size="35" name="compcode" value = <?php echo("'$result[compcode]'");?>></td></tr>

<tr><td><font  face="Arial, Helvetica, sans-serif"><b>Company Name</b></font></td><td>           
 <input  type="text" onKeyPress="return event.keyCode!=13"     onKeyPress="return event.keyCode!=13"   size="35" name="compname" value =<?php echo("'$result[name]'");?>></td></tr>
    
<tr><td><font  face="Arial, Helvetica, sans-serif"><b>Description<g/b></font></td><td>                      
<input  type="text" onKeyPress="return event.keyCode!=13"     onKeyPress="return event.keyCode!=13"  size="35"  name="descrip" value ="<?=$result['description']?>" ></td></tr>   


        
<tr><td><font  face="Arial, Helvetica, sans-serif"><b>Address 1</b></font></td><td>                      
<input  type="text" onKeyPress="return event.keyCode!=13"     onKeyPress="return event.keyCode!=13"   size="35" name="address1"  value =<?php echo("'$result[address1]'");?>></td></tr>
    
  
            
<tr><td><font  face="Arial, Helvetica, sans-serif"><b>Address 2</b></font></td><td>                     
 <input  type="text" onKeyPress="return event.keyCode!=13"     onKeyPress="return event.keyCode!=13"   size="35" name="address2" value =<?php echo("'$result[address2]'");?>> </td></tr>
        
<tr><td><font  face="Arial, Helvetica, sans-serif"><b>City</b></font></td><td>                     
 <input  type="text" onKeyPress="return event.keyCode!=13"     onKeyPress="return event.keyCode!=13"   size="35" name="city" value =<?php echo("'$result[city]'");?>></td></tr>

  
<tr><td><font  face="Arial, Helvetica, sans-serif"><b>State</b></font></td><td>                      
 <input  type="text" onKeyPress="return event.keyCode!=13"     onKeyPress="return event.keyCode!=13"   size="35" name="state" value =<?php echo("'$result[state]'");?>></td></tr> 
        
<tr><td><font  face="Arial, Helvetica, sans-serif"><b>Country</b></font></td><td>                     
<input  type="text" onKeyPress="return event.keyCode!=13"     onKeyPress="return event.keyCode!=13"   size="35" name="country" value =<?php echo("'$result[country]'");?>></td></tr>

<tr><td><font  face="Arial, Helvetica, sans-serif"><b>Pin Code</b></font></td><td>           
 <input  type="text" onKeyPress="return event.keyCode!=13"     onKeyPress="return event.keyCode!=13"   size="10" name="pin" value =<?php echo("'$result[pin]'");?>></td></tr>

<tr><td><font  face="Arial, Helvetica, sans-serif"><b>Mobile No</b></font></td><td>                      
<input  type="text" onKeyPress="return event.keyCode!=13"     onKeyPress="return event.keyCode!=13"   size="10" name="mobile" value =<?php echo("'$result[mobile]'");?>></td></tr>

<tr><td><font  face="Arial, Helvetica, sans-serif"><b>Tel No(s)</b></font></td><td>           
<input  type="text" onKeyPress="return event.keyCode!=13"     onKeyPress="return event.keyCode!=13"   size="35" name="telno" value =<?php echo("'$result[telno]'");?>></td></tr>

    
  
<tr><td><font  face="Arial, Helvetica, sans-serif"><b>Fax No</b></font></td><td>                     
<input  type="text" onKeyPress="return event.keyCode!=13"     onKeyPress="return event.keyCode!=13"   size="35" name="fax" value =<?php echo("'$result[fax]'");?>></td></tr>
      

    
<tr><td><font  face="Arial, Helvetica, sans-serif"><b>E-mail</b></font></td><td>                    
<input  type="text" onKeyPress="return event.keyCode!=13"     onKeyPress="return event.keyCode!=13"   size="35" name="email" value =<?php echo("'$result[email]'");?>></td></tr>

<tr><td><font  face="Arial, Helvetica, sans-serif"><b>Contact Person</b></font></td><td>                   
 <input  type="text" onKeyPress="return event.keyCode!=13"     onKeyPress="return event.keyCode!=13"   size="35" name="contact" value =<?php echo("'$result[contact]'");?>> </td></tr>
    


    
<table cellpading=0 cellspacing=10 width= 50>
<tr><blockquote>
<td>
   <input type =submit name=submit value = "Update"></td> <td><input type =submit name=submit value = "Delete"></td></blockquote></tr>
</table>

</table>
<br><br><font size=1><center><a href= "index.html">Return to index page</center></font>
                                                                             
</body>
</form>

      
