Re: [PHP-DB] Query or code?

2003-11-06 Thread CPT John W. Holmes
From: Peter Beckman [EMAIL PROTECTED] I have this data: Table Log: appid userid points datetype Table Score: appid userid score I want to verify that the last entry in table log of type x is equal to the sum of the scores in table score for the same appid and userid. Can

Re: [PHP-DB] Query or code?

2003-11-06 Thread beckman
On Thu, 6 Nov 2003, CPT John W. Holmes wrote: From: Peter Beckman [EMAIL PROTECTED] I have this data: Table Log: appid userid points datetype Table Score: appid userid score I want to verify that the last entry in table log of type x is equal to the sum of the

Re: [PHP-DB] Query or code?

2003-11-06 Thread John W. Holmes
[EMAIL PROTECTED] wrote: On Thu, 6 Nov 2003, CPT John W. Holmes wrote: From: Peter Beckman [EMAIL PROTECTED] I have this data: Table Log: appid userid points datetype Table Score: appid userid score I want to verify that the last entry in table log of type x is equal to the sum of

Re: [PHP-DB] Query or code?

2003-11-06 Thread Peter Beckman
On Thu, 6 Nov 2003, John W. Holmes wrote: I'd still like an answer to this question. Why is there a need for a separate table with scores? The log is a snapshot in time -- what was the total points at the time of the log entry. The score table is always the accurate current score. Can