INSERT INTO history (TIMESTAMP,DEVICE,TYPE,READING,VALUE)
VALUES('".$timestamp."','$NAME','$TYPE','consumption','".$value."')
[b]ON DUPLICATE KEY UPDATE[i][/i][/b]
VALUE='".$value."';") ;
SELECT cast(sum(VALUE) AS DECIMAL(10,4)) FROM history
WHERE DEVICE='".$NAME."'\
AND READING='consumption'
AND YEAR(TIMESTAMP) = YEAR(curdate())
AND DAY(TIMESTAMP) = curdate()
AND MONTH(TIMESTAMP) = MONTH(curdate()) ;") ;