desc is a keyword,
so change that name to any like desc1...
and try...

hello...have you checked it???
have you got solved your problem...???

i think you have to add one more column like month the you will calculate hours per month by using group by month column...

hello see this example will help you:
t1 table having 4 columns like year,month,day,points...
year month day points
2000 01 01 1
2000 01...

hello vssp...
there is a function called SUM in mysql to calculate total of any numerical column...and if you want to calculate per month,then use limit by 30 days...or created_date < last day of...

can u post your table structure...

You can do it with DATEADD, directly in MySql

SELECT DATEADD(...) AS IncrementedDate from ...
DATEADD("2000-12-01",INTERVAL 1 DAY)

you can use joins for this:

"select * from table1 as t1,table2 as t2 where ti.id=t2.id";


this is simple....
Have look on this url follows:
http://www.tizag.com/mysqlTutorial/mysqljoins.php

make this thread as solved...

SELECT * FROM table WHERE date_col<curdate() and date>DATE_ADD(CURDATE(), INTERVAL -1 DAY)

if u got solution,mark this thread as solved.by this others may see solved threads...

May this will help you:
http://us.php.net/mysqli_multi_query