RPeraltaJr
10/9/2017 - 1:52 AM

Fetch Distinct Categories

<label for="career-areas" class="sr-only">Career Areas</label>
<select name="category" id="career-areas">
    
    <?php if($_GET['category'] == "") { ?>
        <option value="" readonly selected>Career Areas</option>
    <?php } else { ?>
        <option value="" readonly selected>All Career Areas</option>
    <?php } ?>

    <?php 
        $query = "SELECT DISTINCT job_category FROM jobs ORDER BY job_category ASC ";
        $select_categories = mysqli_query($conn, $query);
    
        while($row = mysqli_fetch_assoc($select_categories)) {
            $job_category = $row['job_category'];
            
            if(!empty($job_category)) {
                if($job_category == $_GET['category']) {
                    echo "<option selected value='{$job_category}'>{$job_category}</option>";
                }
                else {
                    echo "<option value='{$job_category}'>{$job_category}</option>";
                }
            }
            
        }
    ?>

</select>