[Phphtmllib-devel] SF.net SVN: phphtmllib:[3224] trunk/open2300/lib/modules/home/widgets/ CurrentConditions.inc

[<he...@us...>]

Revision: 3224
          http://phphtmllib.svn.sourceforge.net/phphtmllib/?rev=3224&view=rev
Author:   hemna
Date:     2009-02-22 18:39:16 +0000 (Sun, 22 Feb 2009)

Log Message:
-----------
fixed first of the year query

Modified Paths:
--------------
    trunk/open2300/lib/modules/home/widgets/CurrentConditions.inc

Modified: trunk/open2300/lib/modules/home/widgets/CurrentConditions.inc
===================================================================
--- trunk/open2300/lib/modules/home/widgets/CurrentConditions.inc	2009-02-22 18:37:30 UTC (rev 3223)
+++ trunk/open2300/lib/modules/home/widgets/CurrentConditions.inc	2009-02-22 18:39:16 UTC (rev 3224)
@@ -46,7 +46,7 @@
         $this->temp_low_high["high"] = $stmt->high;
         
         $year = date("Y");
-        $stmt = $db->queryBindOneRowCache("Select rain_total from weather where datetime like :date order by datetime desc limit 0,1",
+        $stmt = $db->queryBindOneRowCache("Select rain_total from weather where datetime like :date order by datetime asc limit 0,1",
                                           array(":date" => $year.'%'));
         $year_rain_start = $stmt->rain_total;
         


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.