"; while($data[$count] != "%" && $count < $max) { $nation = sprintf("%s%s",$nation,$data[$count]); $count++; } $nation = trim($nation); $count++; //echo "Nation: " . $nation . "
"; $query = sprintf("SELECT id FROM user_tracker WHERE user='%s' AND nation='%s'",$user,$nation); $result = mysql_query($query); if ($result) { if (mysql_num_rows($result) == 0) { $query = sprintf("INSERT INTO user_tracker SET user='%s',nation='%s',seen=NOW()",$user,$nation); // echo $query; mysql_query($query); } else { $query = sprintf("UPDATE user_tracker SET seen=NOW() WHERE user='%s' AND nation='%s'",$user,$nation); mysql_query($query); } } $user = NULL; $nation = NULL; } mysql_close($fp); ?>