You could save all the info in a blob field (no physical file - just some encoded info in a field, which can produce a file on demand), OR just store an url/path for a physical file stored in a certain folder.
E.g.
users table
id (PK)
username
... etc ...
billing table
id (PK)
user_id (Foreign Key on id in users)
dated (billing date)
amount (Billing Amount)
reconciled (Y/N)
invoice_file ***(this is where you store the file's path)
...other fields...
You shoud be able to store a pdf file of the invoice, otherwise you could produce it dynamically from billing info - you can use something like fpdf for either approach
Reputation Points: 1067
Solved Threads: 955
Disgraced Poster
Offline 6,728 posts
since Oct 2006
Unsolved 
