title: Warning: mysqli_stmt::bind_param(): Number of variables doesn't match number of parameters in prepared statement
body: <p>I don't know why this is happening and I keep getting this error Warning: </p>
  
  <blockquote>
    <p>mysqli_stmt::bind_param(): Number of variables doesn't match number of parameters in prepared statement </p>
  </blockquote>
  
  <pre><code>$stmt = $conn-&gt;prepare("SELECT clicks FROM affiliate WHERE ID ='$ID'");
  $stmt-&gt;bind_param("i", $ID);
  $stmt-&gt;execute();
  $stmt-&gt;bind_result($clicks); // Store the result in the $clicks variable
  </code></pre>