[PHP] Time keeping in DB

2009-08-05 Thread Shawn McKenzie
So, obviously not PHP related, but I'm looking for thoughts on the best way to record time sheets in a DB. A time sheet for hours worked per day, not like a time clock where you start and stop. The two possibilities that I have thought of are (these are simplistic, of course I'll be storing

Re: [PHP] Time keeping in DB

2009-08-05 Thread Ashley Sheridan
On Wed, 2009-08-05 at 14:18 -0500, Shawn McKenzie wrote: So, obviously not PHP related, but I'm looking for thoughts on the best way to record time sheets in a DB. A time sheet for hours worked per day, not like a time clock where you start and stop. The two possibilities that I have

Re: [PHP] Time keeping in DB

2009-08-05 Thread Jerry Wilborn
You don't mention what DB you're using, but mySQL can be quite a pain when dealing with multiple time zones. Not impossible, but a hassle none the less. Be sure to set aside a place to store this (and another spot for user preferences to keep track of their TZ). Jerry Wilborn

Re: [PHP] Time keeping in DB

2009-08-05 Thread Wolf
Shawn McKenzie nos...@mckenzies.net wrote: So, obviously not PHP related, but I'm looking for thoughts on the best way to record time sheets in a DB. A time sheet for hours worked per day, not like a time clock where you start and stop. The two possibilities that I have thought of