check freshmeat.net There are several time recording tools. You may find one that works for you. Some of them use MySQL as a backend and some don't. While The idea of using MySQL as the backend for a program like this is good, you can't do it with MySQL alone. (Well, and keep your sanity)
=C= * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * -----Original Message----- From: Simon Tierney [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 09, 2002 3:49 PM To: [EMAIL PROTECTED] Subject: time recording Has anyone on this list used MySQL for time recording? I am a lawyer considering using it for recording time spent on cases where there are many to many relationships between cases, caseworkers, and charge-out rates. I posted to the list under the subject "lookup" and I learned that one cannot dynamically link tables so I am enquiring if anyone has done it before / reckons they know the best way to go about it. case1 is worked on by A for 30 minutes + B for 60 minutes whose charge out rates are £10 per hour and £15 per hour; -what is the most efficient way to get -£20 due on case1; -£5 work value due to A; -£15 work value due to B. given that caseworkers might go A-Z and beyond, any combination of caseworkers might works on any of the cases, there might be a large number of charge-out rates, and these might be related to different case types and different grades of caseworker. I realise this is essentially a design question, but given the way MySQL works I just wanted to check if anyone out there has done something similar. Any (friendly) suggestions would be welcome. Simon Tierney --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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