Re: [PHP-DB] MySQL for Billng Question

At 26.03.2001 22:21, you wrote: >how bout something like this. > >You have 3 columns >TOTAL_HOURS | UNPAID_HOURS | LAST_PAID > >when you are paid, update TOTAL_HOURS to add UNPAID_HOURS and clear [delete, >or set to zero] the UNPAID_HOURS column... LAST_PAID would be type = >timestamp, or date. >Y

RE: [PHP-DB] MySQL for Billng Question

Jeff, Check www.freshmeat.net There are a couple of packages out there that already do this. Some of them use MySQL. If nothing else, you can borrow their database schema. Cal http://www.calevans.com -Original Message- From: Jeff Oien [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26

Re: [PHP-DB] MySQL for Billng Question

how bout something like this. You have 3 columns TOTAL_HOURS | UNPAID_HOURS | LAST_PAID when you are paid, update TOTAL_HOURS to add UNPAID_HOURS and clear [delete, or set to zero] the UNPAID_HOURS column... LAST_PAID would be type = timestamp, or date. You could get pretty elaborate, and mySQL