title: Count and echo the amount of users that have registered
body: <p>I want to make a counter on my home page that goes down with each registration. I am trying to count the number of registered users by id. I put a &quot;?&quot; because I do not know anymore what to put there... I would like to know how to make this work.</p>
  <pre><code>include 'config.inc.php';  
      $max = 1000;
      $result = mysqli_query($mysqli, &quot;SELECT COUNT(*) as aantal FROM aanmeldingen WHERE id ='?&quot;); while($row = mysqli_fetch_array($result)); $aantal = $row['id'];
                 
                  echo &quot;&lt;h2&gt;Er zijn nog &quot;.($max - $aantal).&quot; plaatsen beschikbaar.&lt;/h2&gt;&quot;
  </code></pre>