[SOLVED] Long day... Query help?

[centerwork]

Here is what I am trying to do. In my table there is an Id column and a date column. The Id column will have reoccurring Ids. I need a query that will return the top five reoccurring Ids that occurred with in the last 30 days.

 

Here is what I have so far:

 

$date30 = time()-60*60*24*30;
$query = "SELECT * FROM table WHERE date > $date30 ORDER BY DESC";

 

Any help would be appreciated.

 

 

 

 

[GingerRobot]

Assuming your date field is a unix timestamp, then it'll be something like this:

 

$date = time()-60*60*24*30;
$sql = "SELECT COUNT(*) as count,id FROM yourtable WHERE datefield > $date GROUP BY id ORDER BY count DESC LIMIT 5";

[centerwork]

Thank you, that worked great.