počítadlo - přístupu za měsíc

               id    day    user    view
            1    2012.03.29    1    8
            2    2012.03.30    33    36
            3    2012.03.31    6    9
            4    2012.04.01    5    34
            5    2012.04.02    2    5
            6    2012.04.03    9    39
            7    2012.04.04    3    16

      <?PHP
      $sel_timestamp = mktime(0, 0, 0, date("n"), date("j"), date("Y"));
      $sel_tag = date("Y.m.d",$sel_timestamp);
      $abfrage=mysql_query("select sum(user) from ".$db_prefix."Day where day='$sel_tag'");
      $today=mysql_result($abfrage,0,0);
      if ($today=="") $today=0;
      mysql_free_result($abfrage);
      echo "<td>Today</td><td>$today</td>\n";
     
      ?>

 $abfrage=mysql_query("select sum(user) from ".$db_prefix."Day where day > DATE_ADD(curdate(), INTERVAL 1 MONTH);");
      $mesic=mysql_result($abfrage,0,0);
      if ($mesic=="") $mesic=0;
      mysql_free_result($abfrage);
      echo "<td>Měsíc</td><td>$mesic</td>\n";

  require "configs.php";    
      // Gesamt Besucher ermitteln
      $abfrage=mysql_query("select sum(user) from ".$db_prefix."Day where day > DATE_ADD(curdate(), INTERVAL 1 MONTH)");
      $tyden=mysql_result($abfrage,0,0);
      mysql_free_result($abfrage);
      echo "<td width=\"30%\">Týden:</td><td width=\"20%\">$tyden návštěv</td>\n";