I have the following report to assess site interactions:

PHP Code:
<html>
<head>
<title>Briefing Downloads</title>
</head>
<body>
<p>UserID, BriefingID, Date Downloaded</p>
<?
//dbcon.php
//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 />");
}

?>

</body>
</html>
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!