Guest User

Untitled

a guest
Feb 19th, 2018
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.34 KB | None | 0 0
  1. function getAverage ( $iStat ) {
  2. for ( $i=1; $i<30; $i++ ) {
  3. $sql = sprintf( "SELECT avg( value ) as AVG FROM data WHERE statistic_id = '%d' and day = CURdate()-INTERVAL %d day", $iStat, $i );
  4. $res = mysql_query( $sql );
  5. $obj = mysql_fetch_object( $res );
  6. if ( ! $obj )
  7. return false;
  8. return $obj->AVG;
  9. }
Add Comment
Please, Sign In to add comment