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

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

Revision: 3387
          http://phphtmllib.svn.sourceforge.net/phphtmllib/?rev=3387&view=rev
Author:   hemna
Date:     2010-02-26 19:33:08 +0000 (Fri, 26 Feb 2010)

Log Message:
-----------
fixed times for low/highs

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

Modified: trunk/open2300/lib/modules/home/widgets/TickerConditions.inc
===================================================================
--- trunk/open2300/lib/modules/home/widgets/TickerConditions.inc	2010-02-26 18:05:07 UTC (rev 3386)
+++ trunk/open2300/lib/modules/home/widgets/TickerConditions.inc	2010-02-26 19:33:08 UTC (rev 3387)
@@ -51,7 +51,7 @@
         //TEMPERATURE
         $sql = "select min(temp_out) as low, ".
                "(select max(datetime) from weather where temp_out=".
-                  "(select max(temp_out) from weather where datetime like :date) and datetime like :date)".
+                  "(select min(temp_out) from weather where datetime like :date) and datetime like :date)".
                " as datetime from weather where datetime like :date";    
         $stmt = $db->queryBindOneRowCache($sql, array(":date" => $today.'%'), 60);
         $this->temp_low_high["low"] = $stmt->low;                                  
@@ -80,7 +80,7 @@
         
         $sql = "select min(rel_hum_out) as low, ".
                "(select max(datetime) from weather where rel_hum_out=".
-                  "(select max(rel_hum_out) from weather where datetime like :date) and datetime like :date)".
+                  "(select min(rel_hum_out) from weather where datetime like :date) and datetime like :date)".
                " as datetime from weather where datetime like :date";
         $stmt = $db->queryBindOneRowCache($sql, array(":date" => $today.'%'), 60);
                 


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