Month and Yearly Reports
Posted: Tue Feb 17, 2004 2:34 am
Hi,
i am using Postgres Database and PHP in my Project, i have got some doubts regarding Month and Year functions.
I am passing Date(17-Feb-2004) to my PHP Page,
I want to Calculate, Monthly & Yearly Reports based on Input.
Suppose we have Orders table, (in that we have OrderNo, OrderDate, CustomerName etc)
I need to know, in Feb how many orders i got? and in January etc etc.
and also i will input Year from Combobox like 2000,2002,2003.
I need to know how many Orders i got in Year 2000,.. Year 2002 etc etc, based on Year Input.
i am using Postgres Database and PHP in my Project, i have got some doubts regarding Month and Year functions.
I am passing Date(17-Feb-2004) to my PHP Page,
I want to Calculate, Monthly & Yearly Reports based on Input.
Suppose we have Orders table, (in that we have OrderNo, OrderDate, CustomerName etc)
I need to know, in Feb how many orders i got? and in January etc etc.
and also i will input Year from Combobox like 2000,2002,2003.
I need to know how many Orders i got in Year 2000,.. Year 2002 etc etc, based on Year Input.