How to use the database to achieve the output of the corresponding data (description may be a bit about the problem, confidential)

How to use the database to achieve the output of the corresponding data (description may be a bit of a problem, confidential)?
Now the code has been appended at the end. I want to add an office name, just insert into officename the table.
But here Officename and Officecode are written dead by JS. If this is added, the corresponding problem of the two, the newly added data, there is no corresponding officecode, which need to be manually added in the JS code, it is not reasonable to feel this.

So I think is not through JS, but directly from the database read, Officename table set up two fields name and code
It is possible to do this directly by reading the database and matching the two. How to operate, preferably with an example, thank you

------Solution--------------------
It's all changed.

 
  
 
 


 
 

  
  
 
  
 
  
 
  
 
  
 
  
 
  
 
  
 
  
 
  
 
  
 
   
  
  
 
 
   
  
 
   
 
    
 Office name 
 
    
 
 !--? phpinclude (' conn.php '); $sql = "SELECT * from Officename"; $query =mysql_query ($sql); while ($result =mysql_fetch_array ($query)) {?>  
 
   
 
  
 
  
 
 br> 
  
 
   
  
 