[PHP-DB] Bank Account Register

. 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 -- PHP Database

[PHP-DB] SUM and JOIN together

get 6 for used since there are 2 rows in bought (I think). I figure I could just divide that by the number of results, but is there a 'correct' way of doing it in the SQL statement? Thanks for any help. Please copy me with any replies as I am on the digest. thanks, rogue -- PHP Database Mailing

[PHP-DB] Applications using multiple databases

on this project, I wanted to run this past you all and see what the rest of you think... is there a good reason to develop like this? Should I suggest to begin with - we should change this method so that we only need one database? Thanks for any advice - Rogue -- PHP Database Mailing List (http