Say you want to display the latest visitors on a users profile page. How would you structure this? Perhaps a table called \[code\]uservisitors\[/code\]:
userid (the user that gets a visit)
visitorid (the visitor)
time
And how would you select this with mysql? Without any duplicates, What I mean is if User 1 visits user 2's profile, then 5min later visits again, I dont want it to show both entries only the latestcheers!
