title: Searching an SQL database for rooms within a given capacity
body: <p>Hi everyone I'm working on a room booking system and seem to be returning an error.</p>
  
  <pre><code>$sql = "SELECT * FROM `rooms` WHERE capacity =&gt; '$minCap' AND capacity &lt;= '$maxCap'";
  </code></pre>
  
  <p>This is the error I'm getting:</p>
  
  <p><em>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '=> '150' AND capacity &lt;= '220'' at line 1</em></p>