<?php

function fetchGenres() {
  $db = new Connection();
  $db->open();
  $genres = $db->runQuery("SELECT * FROM clubgenre");
  $db->close();

  $genresArr = array();
  while ($row = $genres->fetch_assoc()) {
    $genresArr[$row["code"]] = $row["category"];
  }
  return $genresArr;
}

function showCategory($genresArr) {
 echo '<p><div class="row">
           <select  name="sweets"  class="input-field col s12">
           <option value="" disabled selected>Choose the ganre</option>';

           foreach ($genresArr as $key => $value) {

               echo '<option value="'. $key .'">'. $value .'</option>';
             }
             // Go to next key
             next($genresArr);

 echo '    </select>

                <input type="submit" name="entergenre" value="Delete Genre" class=" waves-effect waves-green btn-flat">

       </div></p>




       ';
}

showCategory(fetchGenres());
?>