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

TalkPHP (http://www.talkphp.com/forums.php)

- MySQL & Databases (http://www.talkphp.com/mysql-databases/)

- - Query: least 15 records in the last seven days (http://www.talkphp.com/mysql-databases/5555-query-least-15-records-last-seven-days.html)

dsat	08-27-2010 07:07 PM

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
...

Enfernikus

08-27-2010 08:28 PM

Can we see the query you've attempted to write thus far?

All times are GMT. The time now is 05:12 AM.