weewx raindays

#!/usr/bin/php -q
<?
    $username = "weewx";
    $password = "password";
    mysql_connect('localhost', '$username', '$password');
    mysql_select_db('weewx');

    $rainTotal = 0;
    $raindays = 0;

    $start = date("U", mktime(0, 0, 0, 1, 1, date("Y")));
    $stop = date("U", mktime(23, 59, 59, date("m"), date("d"), date("Y")));
    for($date = $start; $date < $stop; $date += 86400)
    {
        $query = "select sum(`rain`) as `rainTotal` from `archive` where `dateTime` >= $date and `dateTime` <= $date + 86359";
        $res = mysql_query($query);
        $row = mysql_fetch_assoc($res);

        if($row['rainTotal'] > 0)
        {
            $rainTotal += $row['rainTotal'];
            $raindays++;
        }
    }

    echo "There are $raindays raindays this year and ".number_format($rainTotal, 1)." mm fell\n";

    $rainTotal = 0;
    $raindays = 0;

    $start = date("U", mktime(0, 0, 0, 1, 1, date("Y")-1));
    $stop = date("U", mktime(23, 59, 59, date("m"), date("d"), date("Y")-1));
    for($date = $start; $date < $stop; $date += 86400)
    {
        $query = "select sum(`rain`) as `rainTotal` from `archive` where `dateTime` >= $date and `dateTime` <= $date + 86359";
        $res = mysql_query($query);
        $row = mysql_fetch_assoc($res);

        if($row['rainTotal'] > 0)
        {
            $rainTotal += $row['rainTotal'];
            $raindays++;
        }
    }

    echo "There are $raindays raindays to this day last year and ".number_format($rainTotal, 1)." mm fell\n";

    $query = "select `dateTime` from archive where `rain` > 0 order by `dateTime` desc limit 1";
    $res = mysql_query($query);
    $row = mysql_fetch_assoc($res);

    echo "Last tip occurred on the ".date("Y-m-d H:i:s", $row['dateTime'])."\n";