Re: 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 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" <jeff@webdesigns1.com> To: "PHP-DB" <php-db@lists.php.net> 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: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com