Sorting by date??

[timbowsr]

Hello,

I am creating a database for our church. It will keep track of finances and member information.

I need to create a quarterly and a yearly report. Is there anyway I can sort by date, so that only those entries that fall within the range of those time periods will be included?

Thanks for any help,
timbowsr

[Hiccup]

The answer is yes.

In your select statement have it only show a range... eg.

WHERE date >= $start_date AND date <=$end_date 

$start_date is either the beginning of the quarter or year and $end_date is the end of the quarter or year you want to display. To figure those out you'll need to use mktime() in the manual or you can have a form to submit both values for you.

If you're storing date in mysql NOT as an integer you have more work ahead of you. I suggest your date field always be an integer so that you can use php functions for simple and complex date calculations.

[xblue]

if you use DATE or DATETIME it is just as fine (even better in my opinion), you can do date arithmetics as well as date formatting right in your queries.