Rettelse af DB forespørgsel

Hej

Jeg har denne kode som forespørger i min DB.

echo "<div align=\"center\"><hr><u><b>Kommende begivenheder</b></u></div>";
$nextyear  = mktime(0, 0, 0, date("m"),  date("d"),  date("Y")+1);
$time = time();
setlocale(LC_ALL, 'danish', "da", "da_DK", "da_DK.iso8859-1");
$maaned = date("n", $time);


$thismonth = gmtdate1('n', time(), $timezone );
$sql = "SELECT DISTINCT date FROM event WHERE  month(date) = '$maaned' ORDER BY date LIMIT 0,3" ;
              $result7events= mysql_query($sql) or die("Cannot query the database.<br>" . mysql_error());
              $next7events  = mysql_num_rows($result7events);
              if ($next7events>0) {
              while ($eventsrow = mysql_fetch_array($result7events)) {
              $showdate = $eventsrow['date'] ;
              list($yyyy, $mm, $dd) = explode('-',$showdate);
              $monthno = $mm;
              $year = $yyyy;
              $showdate = date('d M Y', mktime(0,0,0,$mm,$dd,$yyyy));

          ?>
          <br />&nbsp;<span class="billeft1">Dato :&nbsp;</span><span class="billeft2"><b><u><? echo "&nbsp;"; echo $showdate; ?></u></b></span>
          <?
            $sql = "SELECT DISTINCT * FROM event WHERE  date ='".$eventsrow['date']."'" ;
            $results = mysql_query($sql) or die("Cannot query the database.<br>" . mysql_error());
            $event  = mysql_num_rows($results);
            if ($event>0) {
            while ($row = mysql_fetch_array($results)) {
      ?>

Den lister så alle begivenheder op i inde værende måned, men den skal kunne sortere så den kun viser fremad rettede begivenheder.

d.d. og frem gerne mere end en måned.