On Monday, 15. July 2002 20:28, Paul W. Reilly wrote: Hello Paul,
maybe http://www.mysql.com/doc/D/a/Date_and_time_functions.html could answer your question (Function week() ) Regards Georg > Trying to count weeks! I am doing a personal accounting system in > php/mysql. I have a report section that groups and calculates expenses > into running totals, so that I can see total amount spent in each category. > I would like to add a break down to this that will show me the average > weekly amount. The calculation is easy enough, but I can not figure out > how to get the number of weeks being calculated. > > Any ideas would be greatly appreciated. Right now I am putting in the > number of weeks in manually. > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
