__main.php

<?php /* */ ?>
<div id="main">
  <div id="main-inner">
    <br />
    <div style='text-align:center; font-size:large; color:#00f; font-family:calibri; font-style:italic'>
      <a style='position:relative;left:26px;top:20px'>
        Choose an option to view the report
      </a>
    </div>

    <br /><br />
    <?php
      $host="******";
      $username="**";
      $password="**";
      $database="**";

      $old_error = error_reporting(0);
        @$connection=mysql_connect($host,$username,$password);
        mysql_connect($host,$username,$password);

        if(@mysql_select_db($database))
        {

          $sql="SELECT company FROM admin WHERE (email = '".$email1."' )";
          $result_type = mysql_query($sql,$connection) or die(mysql_error());
//    $row = mysql_fetch_assoc($result_type);
          $env = $row['company'];
        }
        else
        {
          echo  'die( "Unable to select database")';

        }
      error_reporting($old_errors);
          //echo $env;
    ?>

    <form name = 'select_environment' method='post' action='./nav_admin.php'>
      <div>

        <select name='env_select' id = 'env_select' style  = 'position:relative;left:240px;top:35px;'>
          <?php
    //  echo "try";
//          $sql="SELECT company FROM admin WHERE (email = '".$email1."' )";
//          $result_type = mysql_query($sql,$connection) or die(mysql_error());
          //echo $result_type;
            while ($row = mysql_fetch_assoc($result_type))
            {
          $env = $row['company'];
//              echo $env;
//              echo "<option value = '" .$row['company']."' >".$row['company']."</option>";
              echo "<option value = " .$env." >".$env."</option>";
            }
          ?>
        </select>

        <br /><br /><br />
        <input type='submit' name='view' id='view' value='View' onclick= './nav_admin.php' style ='position:relative;left:260px;top:38px;' />
      </div>
    </form>
    <br /> <br /> <br />
  </div><!-- end main inner -->
</div><!-- main -->

<!-- begin side column -->
<div id="side">
  <div id="side-inner">
    <img src="images/logo1.png" alt="H" class="img-right" />
    <br /> <br /><br /><br /><br />
    <p style= "color:#153E7E;font-size:14pt;font-family:calibri;font-align:justify;"> ***** </p>
  </div>
</div><!-- end side column -->

<!-- begin footer -->
<div id="footer">
  <p>*********</p>
</div><!-- end footer -->