\n"); $databases = array(array('hotlunch','localhost'), ); $names = array('Hot Lunches', ); $minutes = 5; $time = time() - 60 * $minutes; $today = date("Y-m-d",$time); for ($i = 0; $i < count($databases); $i++) { $db_name = $databases[$i][0]; $db_host = $databases[$i][1]; $name = $names[$i]; db_query("USE $db_name"); $query = "SELECT DISTINCT school_num,userid,school_name " . "FROM activity_log,schools " . "WHERE activity_time > $time " . "AND school_num = schools.record_num " . "ORDER BY school_name,userid"; $results = db_query($query); $numEntries = db_num_rows($results); printf("%30s: %5d\n",$name,$numEntries); $prev = 0; while ($row = db_fetch_assoc($results)) { extract($row); $dt = db_getVal("SELECT max(activity_time) FROM activity_log WHERE userid = '$userid' AND school_num = $school_num AND activity_time > $time"); if ($school_num != $prev) { echo(" - $school_name\n"); } printf(" -> %20s: %s\n",$dt,$userid); $prev = $school_num; } echo("\n"); } ?>