I am using codeigniter, I am displaying all the job vacancies on one page, each individual job post has a button to view more information about the current post. when I try to pass the id variable for the individual post into the query I keep getting the error below.
Unknown column '$id' in 'where clause'
query code
function get_vacancie($id) {
$query = $this->db->query('SELECT vacancies_id,name, vacancie_desc, pay FROM vacancies where vacancies_id=$id');
return $query = $query->row();
}