Re: [PHP-DB] MySQL for Billng Question

2001-03-26 Thread Andreas D. Landmark
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

2001-03-26 Thread Cal Evans
26, 2001 11:45 AM To: PHP-DB Subject: [PHP-DB] MySQL for Billng Question I want to have a database for my hours for my clients. I want to create a report where it shows only the hours back to the last time I was paid. I have no idea how to go about this. Any help would be appreciated. Jeff Oien

Re: [PHP-DB] MySQL for Billng Question

2001-03-26 Thread olinux
ROTECTED]> To: "PHP-DB" <[EMAIL PROTECTED]> Sent: Monday, March 26, 2001 9:44 AM Subject: [PHP-DB] MySQL for Billng Question > I want to have a database for my hours for my clients. > I want to create a report where it shows only the hours > back to the last time I wa

[PHP-DB] MySQL for Billng Question

2001-03-26 Thread Jeff Oien
I want to have a database for my hours for my clients. I want to create a report where it shows only the hours back to the last time I was paid. I have no idea how to go about this. Any help would be appreciated. Jeff Oien PHP >start here http://www.webdesigns1.com/php/ -- PHP Database Mailing