title: PHP/MySql Multiple Dropdowns dont want option values visible in page source
body: <p>What I would like to do is find a way to "hide" the option value listing from the page source if possible.</p>
  
  <p>I have successfully created a page with multiple drop downs (6 now, will be 15+ in total); database queries are working, drop downs are working, posting selections and results are visible in a separate processing page, HOWEVER;
  The option values are showing in the page source.</p>
  
  <p><strong>Page Design</strong> (for this example)
  test.php - contains db connect (will change that to separate include_once later), queries, option values code, and table data.
  index.php - contains only an include statement calling test.php.</p>
  
  <p>Running test.php in a browser exposes queries (which I don't want) and loading the index that is including test.php hides queries, but shows options which I prefer not to have.
  I have searched everywhere (maybe I am not asking the question properly) and have tried to run the sql in one page and posted the result to another, but I cannot get it to work.</p>
  
  <p><strong>What I wanted to do:</strong>
  Run MySQL queries in a separate "function" page and then call the output (select name) to another (HTML) page and embed the dropdowns into a cell of a table.</p>
  
  <p><strong>Questions:</strong></p>
  
  <ol>
  <li>Is it possible to hide the option values in the index.php page? </li>
  <li>Is this my design flaw and if so, what is a better way?tem</li>
  <li>How do I run queries in one page, and then call the output of that query as a drop down into an HTML page?</li>
  </ol>
  
  <p>test.php (Shortened example)</p>
  
  <pre><code>    &lt;!--mo--&gt;
  &lt;td colspan="2"&gt;&lt;div align="right"&gt;&lt;font face="Arial, Helvetica, sans-serif"&gt; 
  &lt;?php
  $query = "SELECT date_code_mo, date_code_mo_desc FROM tbl_gm_assy_date_code_mo ORDER BY           date_code_mo ASC";
  echo '&lt;select name="date_mo"&gt;';
  if ($result = mysqli_query($link, $query)) {
  while ($row = mysqli_fetch_assoc($result)) {
  echo '&lt;option value="' . $row['date_code_mo_desc'] . '"&gt;' . $row['date_code_mo'] . '&lt;/option&gt;';      
  }
  mysqli_free_result($result);
  }
  echo '&lt;/select&gt;';
  ?&gt;
  &lt;/font&gt;&lt;/div&gt;&lt;/td&gt;
  &lt;!--week--&gt;
  &lt;td colspan="2"&gt;&lt;div align="left"&gt;&lt;font face="Arial, Helvetica, sans-serif"&gt; 
  &lt;?php
  $query = "SELECT date_code_wk, date_code_wk_desc FROM tbl_gm_assy_date_code_wk ORDER BY     date_code_wk ASC";
  echo '&lt;select name="date_wk"&gt;';
  if ($result = mysqli_query($link, $query)) {    
  while ($row = mysqli_fetch_assoc($result)) {
  echo '&lt;option value="' . $row['date_code_wk_desc'] . '"&gt;' . $row['date_code_wk'] . '&lt;/option&gt;';
  }
  mysqli_free_result($result);
  }
   echo '&lt;/select&gt;';
   ?&gt;
  </code></pre>
  
  <p>index.php source (table definitions not shown)</p>
  
  <pre><code>&lt;select name="date_mo"&gt;&lt;option value="Janurary"&gt;01&lt;/option&gt;&lt;option value="Feburary"&gt;02&lt;/option&gt;&lt;option value="March"&gt;03&lt;/option&gt;&lt;option value="April"&gt;04&lt;/option&gt;&lt;option value="May"&gt;05&lt;/option&gt;&lt;option value="June"&gt;06&lt;/option&gt;&lt;option value="July"&gt;07&lt;/option&gt;&lt;option value="August"&gt;08&lt;/option&gt;&lt;option value="September"&gt;09&lt;/option&gt;&lt;option value="October"&gt;10&lt;/option&gt;&lt;option value="November"&gt;11&lt;/option&gt;&lt;option value="December"&gt;12&lt;/option&gt;&lt;/select&gt;
  
  &lt;select name="date_wk"&gt;&lt;option value="First"&gt;A&lt;/option&gt;&lt;option value="Second"&gt;B&lt;/option&gt;&lt;option value="Third"&gt;C&lt;/option&gt;&lt;option value="Fourth"&gt;D&lt;/option&gt;&lt;option value="Fifth"&gt;E&lt;/option&gt;&lt;/select&gt; 
  </code></pre>
  
  <p>I have used a lot of examples available on here to get this far, and I am sure it is something small that has been missed, regardless, THANKS TO YOU ALL!</p>