Bank Account Register

From: Date: Tue, 02 Mar 2004 15:23:56 +0000
Subject: Bank Account Register
Groups: php.db 
Request: Send a blank email to php-db+get-33256@lists.php.net to get a copy of this message
Hi all, Please CC me on any reply - I get the digest :) I am working on a project where I need to implement something that most resembles a checkbook register, where I am tracking pre-paid hours bought vs. hours used on-site. I am getting a bit stuck on the best structure for the mysql table, and would like some suggestions. In the end, I need to be able to run a report where by date it displays hours purchased, and hours used like in a check register:
DATE    DESC.                   BAL.
2/23/04 Purchased 10 hours      10hrs. remaining
2/24/04 Job 2 used 5 hours       5hrs. remaining
2/24/04 Purchased 20 hours      25hrs. remaining
Like so... Would it be best to have 1 table with a field for transaction type and keep all the ins and outs in one table, or have two tables one where I track purchased hours and the other where I track used hours? Thanks, Rogue

« previous php.db (#33256) next »