- Messages
- 4,715
- Reaction score
- 2
- Points
- 28
pano po ang codes ng daily, weekly saka monthly reports... tnx... ^^
napansin mo date related yang tanong mo?
so kung sakaling SQL commands ang ginamit mo madali lang yan
malamang ganito pag weekly
SELECT * FROM TABLE WHERE TRANDATE BETWEEN "1/1/2010" AND "1/7/2010"
malamang january 2010 to
SELECT * FROM TABLE WHERE MONTH(yourdate) = 1 AND YEAR(yourdate) = 2010
sa daily malamang alam mo na
pag mrunong kayo ng SQL commands madali lang lahat yan