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 can do a TON of cool tricks with
the numbers... depends what your uses may be. If you are using it to
generate statements it may be worth more time than simply "keeping track"
I picked up SAM'S learn SQL in 10 minutes. I really liked it, considering
that I don't need to use a whole lot of mySQL functions, it's a wonderful
little reference and I have learned some neat things real fast. I
understand that it is far from "complete" but i feel it is worth it for me
[starting out]
olinux
----- Original Message -----
From: "Jeff Oien" <[EMAIL PROTECTED]>
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 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 List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]