title: display records of a specific year in php mysql
body: <p>I have a system that shows records year wise. I have dropdown menu from which user selects year, and I am storing that value in variable <code>$year</code>. So now when <code>$year = 2013-2014</code>, it should not display records of year 2014-2015. BTW when I insert my contractNumber, I also insert the year which user has selected during the login. e.g. <code>contractNumber = 1#2013-2014</code>.</p>
  
  <p>I tried this queries:</p>
  
  <pre><code>SELECT * FROM contract WHERE contarctNumber RLIKE "^$year";
  </code></pre>
  
  <p>Now when I select year 2014-2015, it still displays all the records from year 2013-2014.</p>
  
  <p>Any suggestions?</p>