title: how to get last date form DB table mysql
body: <p>i have this table in my DB</p>
  
  <p>categoriesSupports-> id, category_id, support_id, date</p>
  
  <p>the thing is that i need to extract all support_id where date is the closest date from now... </p>
  
  <p>something like this... if there is in the DB table </p>
  
  <pre><code>id, category_id, support_id, date
  1       1             1       2010-11-23
  2       1             2       2010-11-25
  3       1             1       2010-11-26
  4       1             3       2010-11-24
  </code></pre>
  
  <p>i need to get just </p>
  
  <pre><code>id, category_id, support_id, date
  2       1             2       2010-11-25
  3       1             1       2010-11-26
  4       1             3       2010-11-24
  </code></pre>
  
  <p>So for better undestanding... i need <strong>the closest date</strong> for <strong>each support</strong> and i only have date from the past...
  Ive being trying a lot and I dont know how... </p>