Department database design (6) change import from pubmed

 http://localhost/ubc_surgery_pub/scripts/manage/pubmedimport/index.php
line 314 change
<link rel="stylesheet" type="text/css" href="../../../demosite/css/search.css" />
to
<link rel="stylesheet" type="text/css" href="../../../demosite/css/search.css" />
<link href="../../../demosite/css/ubc-clf-full.min.css" rel="stylesheet">
<link href="../../../demosite/css/ubc-home.css" rel="stylesheet">

line 319 change
<h1>Import PubMed summary data into publications database</h1>
<br />
<div class="content">
to
<div class="container">
<header id="ubc7-header" class="row-fluid expand" role="banner">       
<div class="header-text">Import PubMed summary data into publications database</div>
</header>

<!-- UBC Unit Navigation -->
        <div id="ubc7-unit-menu" class="navbar expand" role="navigation">
            <div class="navbar-inner expand">
                    <nav class="nav-collapse collapse" id="ubc7-unit-navigation">
                        <ul class="nav">
     <li ><a href="/ubc_surgery_pub/demosite/"  >Home</a></li>
    <li ><a href="http://surgery.med.ubc.ca/"  >Department of Surgery</a></li>
    <li>
       <a href="/ubc_surgery_pub/scripts/manage/"> Go to Administration</a></li>
        <li class="active"><a href=""  >Import from PubMed data</a></li><li>
        <a href="/ubc_surgery_pub/demosite/index.php?action=logout">Logout admin</a>

</li>
 
</ul>                    </nav><!-- /.nav-collapse -->
                </div>
        </div><!-- /navbar -->
        <!-- End of UBC Unit Navigation -->   
<div id="content" class="expand row-fluid content" role="main">
line 465 add
<footer class="row-fluid expand" id="ubc7-footer" role="contentinfo">
  <div class="footer-text">
        Copyright © 2014 CESEI, Department of Surgery, UBC. All rights reserved.
  </div>
</footer>
</div>
line 22 remove:
echo "\n<p style='text-align:right;'>[<a href='$config[pageshomeurl]'>Back to administration homepage</a>]</p>"; 
line 365 add
echo "<option value=0>Unknown</option>";
C:\Users\jiansen\Desktop\CAS\jiansen_dir\www_cesei0_mobile\ubc_surgery_pub\scripts\manage/common.php, line 449
 $res = mysql_query("SELECT * FROM DEPTS ORDER BY NAME", connectpubsdb()); 
to
 $res = mysql_query("SELECT * FROM DEPTS", connectpubsdb());