<?php
require '../configs/app_top.php';
$course_code = safe_input($_GET["code"]);
if ($course_code == "") {
  echo "";
} else {
  try {
    $sql = "select sc_id, `sc_name` "
            . "FROM " . TBL_SUBJECT_COMBINATIONS . " WHERE 1 AND sc_course_code = :code ORDER BY sc_id ASC";

    $stmt = $DB->prepare($sql);
    $stmt->bindValue(":code", safe_input($course_code));
    $stmt->execute();
    $results = $stmt->fetchAll();
  } catch (Exception $ex) {
    #$ex->getMessage();
  }
}
?>
<div class="form-group">
  <label class="col-2 control-label" for="sub_com"><span class="required">*</span>Combination: </label>
  <div class="col-6">
    <input type="hidden" name="scom" id="scom" value="<?php echo count($results); ?>">
    <select class="form-control" name="sub_com" id="sub_com">
      <option value="">select</option>
      <?php
      foreach ($results as $cr) {
        echo '<option value="' . safe_output($cr["sc_id"]) . '" ' . $s . ' >' . safe_output($cr["sc_name"]) . '</option>';
      }
      ?>
    </select>
  </div>
</div>