Select array?

mod-edit

slecht geformatteerde code hersteld.

<?php
  $sql_game = "SELECT game FROM projects_game";
  $sql_xgame = "SELECT xgame FROM projects_xgame";
  $sql_type = "SELECT type FROM projects_type";
  
  $res_game = mysql_query($sql_game) or die(mysql_error());
  $res_xgame = mysql_query($sql_xgame) or die(mysql_error());
  $res_type = mysql_query($sql_type) or die(mysql_error());
  
  while ($row_game = mysql_fetch_assoc($res_game)) {
      if ($row_game['game'] != null) {
          $aGames[] = $row_game['game'];
      }
  }
  while ($row_xgame = mysql_fetch_assoc($res_xgame)) {
      if ($row_xgame['xgame'] != null) {
          $aXGame[] = $row_xgame['xgame'];
      }
  }
  while ($row_type = mysql_fetch_assoc($res_type)) {
      if ($row_type['type'] != null) {
          $aType[] = $row_type['type'];
      }
  }
  
  echo "<select name=\"game\" class='textbox'>";
  foreach ($aGames as $gKey => $gValue) {
      echo "<option value='" . $gKey . "'";
      echo ">" . $gValue . "</option>";
  }
  echo '</select>';
  
  echo "<select name=\"xgame\" class='textbox'>";
  foreach ($aXGame as $gKey => $gValue) {
      echo "<option value='" . $gKey . "'";
      echo ">" . $gValue . "</option>";
  }
  echo '</select>';
  
  echo "<select name=\"type\" class='textbox'>";
  foreach ($aType as $gKey => $gValue) {
      echo "<option value='" . $gKey . "'";
      echo ">" . $gValue . "</option>";
  }
  echo '</select>';
?>