How many records since last value?
Posted: Sun Aug 23, 2009 9:52 am
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!
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!