Page 1 of 1

How many records since last value?

Posted: Sun Aug 23, 2009 9:52 am
by jmansa
Is it possible to look through db tables/columns for a specific user and count how long back forinstance he has reported the number "3"?

If my table looks like this:
userid, rec1, rec2, rec3

So if the user (1) has recorded 3 times like this:
uid, 2, 2, 3
uid, 1, 2, 2
uid, 2, 1, 2


The reuslt of my query should be "6":

Is this possible?!?! and if yes... HOW?

Thanks in advance!

Re: How many records since last value?

Posted: Sun Aug 23, 2009 11:24 am
by John Cartwright
I don't see how you would get 6 from that dataset, can you explain again?