Cacher is the code snippet organizer for pro developers

<?php
  // Create empty array
    $total_jobs = array();

    // Query to get # of jobs
    $query = "SELECT * FROM jobs ";
    $count_query = mysqli_query($conn, $query);

    // Check if query failed
    if ($count_query = mysqli_query($conn, $query)) {
        // Fetch associative array 
        while ($row = mysqli_fetch_assoc($count_query)) {
            $total_jobs[] = $row['job_id']; // Insert into array
        }
    } else {
        die('QUERY FAILED' . mysqli_error($conn));
    }
?>