I use the Now() function, and I just set my format to "ww" without parenthesis and it gives me the current week number.
--- Georg Richter <[EMAIL PROTECTED]> wrote: > 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 > __________________________________________________ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com --------------------------------------------------------------------- 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
