Cacher is the code snippet organizer for pro developers

<a href="job-description/?id=<?php echo $job_id; ?>">
	<?php echo $job_title; ?>
</a>

<?php
  // GET data for specific user clicked
  if(isset($_GET['id'])) {
      $the_job_id = $_GET['id'];
      $query = "SELECT * FROM vistaprint_jobs WHERE system_id = $the_job_id ";
      $select_job_query = mysqli_query($connection, $query);
      while($row = mysqli_fetch_assoc($select_job_query)) {
				$job_id = $row['system_id'];
				$job_title = $row['job_title'];
				$job_location = $row['location'];
				$job_category = $row['category'];
				$job_posting = $row['job_posting'];

				$job_title = mysqli_real_escape_string($connection, trim($job_title));
				$job_location = mysqli_real_escape_string($connection, trim($job_location));
				$job_category = mysqli_real_escape_string($connection, trim($job_category));
				$job_posting = mysqli_real_escape_string($connection, trim($job_posting));
      }
    }
    else {
        header("Location: index.php");
    }
  ?>
  
  <h2><?php echo $job_title; ?></h2>