hi, i am developing a webpage by using PHP for inserting / displaying data on daily basis and storing the database in Mysql. now i want to make one report which gives sum on monthly basis. my table is containining two fields 1) date (in YYYY-MM-DD format) 2) unit_consumed (integer) with best wishes balwant -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php