<?php include("../../include/dbconnect.php");?>
<title>Company Edit page</title>
<body background="blater01.gif" topmargin=0>
<center>
<table cellpadding=0 cellspacing=4 width=590>
<tr>
<td style="padding:3px;" colspan=2 bgcolor="#93BEE2"><font ><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=mysql_query("select distinct compcode,name,address1,address2,city,state,country,pin,email,st,cst,std,telno,fax,telex,contact,areacode,tin,buyertype,account_year from company where record = '$record' order by name") or die(mysql_error());

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

<tr><td><font class="sbd"<b>Company Code</b></font></td><td>           
 <input type="text"    onKeyPress="return event.keyCode!=13"   size="35" name="bcode" value = <?php echo("'$row[0]'");?>></td></tr>


<tr><td><font class="sbd"<b>Company Type</b></font></td><td>           
 <input type="text"    onKeyPress="return event.keyCode!=13"   size="35" name="buyertype" value = <?php echo("'$row[18]'");?>></td></tr>


<tr><td><font class="sbd"<b>Company Name</b></font></td><td>           
 <input type="text"    onKeyPress="return event.keyCode!=13"   size="35" name="bname" value =<?php echo("'$row[1]'");?>></td></tr>
    
        
<tr><td><font class="sbd"<b>Address 1</b></font></td><td>                      
<input type="text"    onKeyPress="return event.keyCode!=13"   size="35" name="baddress1"  value =<?php echo("'$row[2]'");?>></td></tr>
    
  
            
<tr><td><font class="sbd"<b>Address 2</b></font></td><td>                     
 <input type="text"    onKeyPress="return event.keyCode!=13"   size="35" name="baddress2" value =<?php echo("'$row[3]'");?>> </td></tr>
        
<tr><td><font class="sbd"<b>City</b></font></td><td>                     
 <input type="text"    onKeyPress="return event.keyCode!=13"   size="35" name="bcity" value =<?php echo("'$row[4]'");?>></td></tr>

  
<tr><td><font class="sbd"<b>State</b></font></td><td>                      
 <input type="text"    onKeyPress="return event.keyCode!=13"   size="35" name="bstate" value =<?php echo("'$row[5]'");?>></td></tr> 
        
<tr><td><font class="sbd"<b>Country</b></font></td><td>                     
<input type="text"    onKeyPress="return event.keyCode!=13"   size="35" name="country" value =<?php echo("'$row[6]'");?>></td></tr>

<tr><td><font class="sbd"<b>Pin Code</b></font></td><td>           
 <input type="text"    onKeyPress="return event.keyCode!=13"   size="10" name="bpin" value =<?php echo("'$row[7]'");?>></td></tr>
    
<tr><td><font class="sbd"<b>E-mail</b></font></td><td>                    
<input type="text"    onKeyPress="return event.keyCode!=13"   size="35" name="bemail" value =<?php echo("'$row[8]'");?>></td></tr>


<tr><td><font class="sbd"<b>Sales Tax RC No</b></font></td><td>           
<input type="text"    onKeyPress="return event.keyCode!=13"   size="35" name="bst" value =<?php echo("'$row[9]'");?>> </td></tr>
    
<tr><td><font class="sbd"<b>CST No</b></font></td><td>                      
<input type="text"    onKeyPress="return event.keyCode!=13"   size="35" name="bcst" value =<?php echo("'$row[10]'");?>></td></tr>      

<tr><td><font class="sbd"<b>TIN No</b></font></td><td>                      
<input type="text"    onKeyPress="return event.keyCode!=13"   size="35" name="tin" value =<?php echo("'$row[17]'");?>></td></tr>      

<tr><td><font class="sbd"<b>Accounting Year</b></font></td><td>                      
<input type="text"    onKeyPress="return event.keyCode!=13"   size="35" name="a_year" value =<?php echo("'$row[19]'");?>></td></tr>   
        
<tr><td><font class="sbd"<b>Std Code</b></font></td><td>                      
<input type="text"    onKeyPress="return event.keyCode!=13"   size="10" name="bstd" value =<?php echo("'$row[11]'");?>></td></tr>

<tr><td><font class="sbd"<b>Tel No(s)</b></font></td><td>           
<input type="text"    onKeyPress="return event.keyCode!=13"   size="35" name="btelno" value =<?php echo("'$row[12]'");?>></td></tr>
    
  
<tr><td><font class="sbd"<b>Fax No</b></font></td><td>                     
<input type="text"    onKeyPress="return event.keyCode!=13"   size="35" name="bfax" value =<?php echo("'$row[13]'");?>></td></tr>
      
<tr><td><font class="sbd"<b>Telex</b></font></td><td>                     
<input type="text"    onKeyPress="return event.keyCode!=13"   size="35" name="bgram" value =<?php echo("'$row[14]'");?>></td></tr>
    

<tr><td><font class="sbd"<b>Contact Person</b></font></td><td>                   
 <input type="text"    onKeyPress="return event.keyCode!=13"   size="35" name="contact" value =<?php echo("'$row[15]'");?>> </td></tr>
    
  <tr><td><font class="sbd"<b>Area Code</b></font></td><td>                   
 <input type="text"    onKeyPress="return event.keyCode!=13"   size="35" name="areacode" value =<?php echo("'$row[16]'");?>> </td></tr>
    
<table cellpading=0 cellspacing=10 width= 50>
<tr>
<td>
 <blockquote>  <input type =submit name=submit value = "Update"></td> <td><input type =submit name=submit value = "Delete"></blockquote>
</table>

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

      
