title: how to show entry from table if a variable is not present in my joined table?
body: <pre><code>$sql = "SELECT * FROM questions q JOIN answered a ON a.ans_qsId = q.qs_id WHERE a.ans_myId != '$id' ORDER BY q.qs_date ASC LIMIT 1;";
  </code></pre>
  
  <p>I have 1 table for questions and another table for who has answered which question.
  I want a question to be loaded onto the page if the user's id is not present in the answered table (so they dont answer the same question again).</p>
  
  <p>I'm not sure why my sql code is not working, I have tried many variations (also with LEFT), not managed to find an answer googling for an hour.</p>
  
  <p>My answered table is empty at the moment, do I need something to say "if empty do this" ?</p>
  
  <p>Thanks!</p>