title: Using MySQL results array more than once
body: <p>I have the following code in my page</p>
  
  <pre><code>    &lt;?php
      $dbc = mysql_connect();
      $db = mysql_select_db();
      $results= mysql_query("SELECT * FROM tbl_teams");
  ?&gt;
  &lt;div class="datagrid"&gt;&lt;table&gt;
  &lt;thead&gt;&lt;tr&gt;&lt;th&gt;header&lt;/th&gt;&lt;th&gt;header&lt;/th&gt;&lt;th&gt;header&lt;/th&gt;&lt;/tr&gt;&lt;/thead&gt;
  &lt;tbody&gt;
  &lt;tr&gt;
  &lt;td&gt;
  &lt;select name="game1_team1"&gt;&lt;option value="0"&gt;Choose Team 1&lt;/OPTION&gt;&lt;?php while($row = mysql_fetch_array($results)) {echo '&lt;option value="'.$row['team_ID'].'"&gt;'. $row['team_name'].'&lt;/option&gt;';}?&gt;&lt;/select&gt;
  &lt;/td&gt;
  &lt;td&gt;Vs.&lt;/td&gt;
  &lt;td&gt;
  &lt;select name="game1_team2"&gt;&lt;option value="0"&gt;Choose Team 2&lt;/OPTION&gt;&lt;?php while($row = mysql_fetch_array($results)) {echo '&lt;option value="'.$row['team_ID'].'"&gt;'. $row['team_name'].'&lt;/option&gt;';}?&gt;&lt;/select&gt;
  &lt;/td&gt;
  &lt;/tr&gt;
  </code></pre>
  
  <p>The code shows the names of football teams from the MySQL table in dropdown game1_team1 but not in game1_team2; it's as though I can't use the same query twice. How do I remedy this? I'd like to use the same values for 60 identical drop downs on the page.</p>
  
  <p>Can I store the values into an array and resuse them in each dropdown?</p>