<?php

print "
         <form name=\"search\" method=\"post\" onsubmit=\"docClickLoader.submitInto(this, 'targetArea', event)\" action=\"\">
          <fieldset id=\"search\">
           <legend>
            <img src=\"$ClearsiteBaseURL/images/search1.png\" alt=\"\" />
            <br />
           </legend>
           <input id=\"searchbar\" type=\"text\" size=\"18\" name=\"searchtext\" onkeyup=\"showResult(this.value)\" /><br />
           <label><b>Switch:</b></label><br />
           <input name=\"field\" value=\"mac\" type=\"radio\" class=\"radio\" onchange=\"showResult(searchtext.value)\" />
           <label>MAC</label><br />
           <input name=\"field\" value=\"host_ip\" type=\"radio\" class=\"radio\" onchange=\"showResult(searchtext.value)\" />
           <label>IP</label><br />
           <input name=\"field\" value=\"host_name\" checked=\"checked\" type=\"radio\" class=\"radio\" onchange=\"showResult(searchtext.value)\" />
           <label>Name</label><br />
           <label><b>CSS:</b></label><br />
           <input name=\"field\" value=\"owner\" type=\"radio\" class=\"radio\" onchange=\"showResult(searchtext.value)\" />
           <label>Owner</label><br />
           <input name=\"field\" value=\"cr_name\" type=\"radio\" class=\"radio\" onchange=\"showResult(searchtext.value)\" />
           <label>Content Rule</label><br />
           <input name=\"field\" value=\"sv_name\" type=\"radio\" class=\"radio\" onchange=\"showResult(searchtext.value)\" />
           <label>Service</label>
          </fieldset>
         </form>
         <br />
         <form name=\"menu_tree_loc\" method=\"post\" onsubmit=\"docClickLoader.submitInto(this, 'menuTree', event)\" action=\"\">
          <fieldset id=\"nav_tree\">
           <legend>
            <img src=\"$ClearsiteBaseURL/images/nav-tree1.png\" alt=\"\" />
            <br />
           </legend>
           <select class=\"dropdown\" name=\"location_ID\" onchange=\"showResult2(this.value)\">
            <option value=\"\">Choose Location</option>
";

mysql_connect("$DBhost:$DBport",$DBuser,$DBpass) or die("Unable to connect to database");
@mysql_select_db("$DBName") or die("Unable to select database $DBName");
$sqlquery = "SELECT DISTINCT city, state, location_id FROM location ORDER BY city";
$result = mysql_query($sqlquery);

while ($row = mysql_fetch_assoc($result)) {
  print "     <option value=\"$row[location_id]\">$row[city], $row[state]</option>
";
};

mysql_close();

print "
           </select>
          </fieldset>
         </form>
         <br />
         <div id=\"menuTree\">
         </div>
";

?>