TalkPHP - View Single Post - Query: least 15 records in the last seven days

dsat · 08-27-2010, 07:07 PM

How to make a query, if I want to find a userID who is at least 15 records in the last seven days of the table "example" field 'cID=2'.

table "example"

pID | cID | userID | rTime
1, 2, 34, 2010-11-04 16:36:29
2, 2, 27, 2010-11-04 18:45:02
...

08-27-2010, 07:07 PM	#1 (permalink)
dsat The Visitor Join Date: Aug 2010 Posts: 1 Thanks: 0	Query: least 15 records in the last seven days How to make a query, if I want to find a userID who is at least 15 records in the last seven days of the table "example" field 'cID=2'. table "example" pID \| cID \| userID \| rTime 1, 2, 34, 2010-11-04 16:36:29 2, 2, 27, 2010-11-04 18:45:02 ...