title: SQL join using prepared statement
body: <p>I have 3 tables jobseeker, certification and education which i want to query using prepared statement. This is my code</p>
  
  <pre><code>$username= $_SESSION['username'];
  $query = $pdo-&gt;prepare("SELECT jobseeker.username ,  jobseeker.first_name , jobseeker.last_name , education.university , certification.institution ,  from jobseeker inner join education on jobseeker.username=education.jobseeker_username inner join certification on jobseeker.username=certification.jobseeker_username where username=:username");
  $query-&gt;bindParam(':username' , $username);
  $query-&gt;execute();
  $data = $query-&gt;fetchAll(PDO::FETCH_ASSOC);
  return $data;
  </code></pre>
  
  <p>it isn't working.</p>