From bitter experience I'll suggest that it's a REALLY GOOD idea to store invoice totals, subtotals, etc. in either the invoice header record. If not rounding errors, or some small change in logic, can come back and bite you - accountants get *really* upset when that 3000.00 invoice becomes 3000.01 or 2999.99.
Know what else? THEY'LL NEVER LET YOU FORGET.
Don't call it denormalization - call it history.
Cheers - Miles
At 03:53 PM 8/5/2003 +0800, Jason Wong wrote:
On Tuesday 05 August 2003 15:43, Ben C. wrote: > Yes, I know. However, the while() loop should generate all the invoice in > a list.
As has been pointed out the query only results in a single row. So how would the while-loop "generate all the invoice[s]"? It's only ever given a single row to play with.
And has also been pointed out, could you state clearly:
- what exactly you're trying to do - what your database schema is - what you tried that didn't work, and *how* it didn't work
-- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * ------------------------------------------ Search the list archives before you post http://marc.theaimsgroup.com/?l=php-general ------------------------------------------ /* I appoint you ambassador to Fantasy Island!!! */
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
