title: how to get all rows except with specific values
body: <p>Hello is there a way to only get the <code>survey_name</code> that the organisation has not used yet?</p>
  
  <pre><code>`survey table`
  +-----------+-------------+
  | survey_id | survey_name |
  +-----------+-------------+
  |         1 | name1       |
  |         2 | name2       |
  |         3 | name3       |
  |         4 | name4       |
  |         5 | name5       |
  +-----------+-------------+
  
  `link table`
  +---------+-------------+-----------------+
  | link_id | survey_link | organisation_id |
  +---------+-------------+-----------------+
  |       1 | 1(survey_id)|        1        |
  |       2 | 2           |        1        |
  |       3 | 2           |        2        |
  |       3 | 3           |        2        |
  |       3 | 6           |        2        |
  +---------+-------------+-----------------+
  
  </code></pre>
  
  <p>In this database structure you would see this for each organisation:</p>
  
  <p>available surveys organisation1:</p>
  
  <ul>
  <li>name3</li>
  <li>name4</li>
  <li>name5</li>
  </ul>
  
  <p>available surveys organisation1:</p>
  
  <ul>
  <li>name1</li>
  <li>name4</li>
  <li>name5</li>
  </ul>
  
  <p>I have tried using 
  <code>WHERE NOT (survey_id= $row['survey_id'])</code></p>
  
  <pre class="lang-php prettyprint-override"><code>//get all survey's that are in use
  $sqlCheckLink = "SELECT `survey_id` FROM `link_info` WHERE `organisation_id`=".$_SESSION['organisation_id']."";
      $resultCheck = mysqli_query($conn, $sqlCheckLink);
      if ($resultCheck -&gt;num_rows &gt; 0) {
          while ($id = $resultCheck -&gt; fetch_assoc()) {
              //show all surveys that are available
              $sqlGetSurveys = "SELECT * FROM `survey_info` WHERE NOT (survey_id = ".$id['survey_id'].")";
              $resultAllSurveys = mysqli_query($conn, $sqlGetSurveys);
  
              if ($resultAllSurveys -&gt;num_rows &gt; 0) {
                  while ($row = $resultAllSurveys-&gt; fetch_assoc()) {
                     //echo content
                  }
              }
          }
      }
  
  </code></pre>
  
  <p>from <a href="https://stackoverflow.com/questions/7198748/select-all-except-some-rows">here</a>
  But it does not seem to work...
  With this method I get also the surveys that are in use.</p>
  
  <p>If someone could help it would be really appreciated!</p>