I have the following report to assess site interactions:

PHP Code:
<title>Briefing Downloads</title>
<p>UserID, BriefingID, Date Downloaded</p>
//DB connection stuff - pulled out.

$grab=@mysql_query("SELECT * FROM tracking");
while ($result=mysql_fetch_array($grab)) {
echo($result['user_id']."#".$result['briefing_id']."#".$result['date_loaded']."<br />");


However, the only "hits" of value to us are unique "briefings" pulled within a 24hr period. I basically need to only have one instance of a record where the user_id and briefing_id are identical within 24hrs.

Don't have a clue how to get this done - advice appreciated as always!