Posted by Ken on 04/19/05 15:53

On 4/19/05, Ryan A <ryan@coinpass.com> wrote:
> Hey,
> Am a bit puzzled as to how to do this, I am modifying a profiles/dating
> site, the site works like this:
> if you are a "guest" you can see only limited details of a profile, if you
> have logged in, you see many more details.
>
> On the profile page there should be "last 10 visitors", it will not register
> the guests, but if someone had logged in and visited your profile, it should
> show their username....if there are 10 enteries in the db and when the 11th
> person comes...then the first person who came should be "bumped" off and the
> 11th person takes his place and so on....
>
> I hope i have explained it well, I dont think many of you even needed that
> long explanation as you might have already seen this on many sites and knew
> what i was talking about by the second line, but better more infomation than
> less right?
>
> Any ideas, links,code or classes on how i can implement this?
>
> Thanks,
> Ryan
>
> --
> No virus found in this outgoing message.
> Checked by AVG Anti-Virus.
> Version: 7.0.308 / Virus Database: 266.9.16 - Release Date: 4/18/2005
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

Instead of having a seperate table to see the latest people logged on,
isn't it better to query an existing user table based on the last
login time?

SELECT username from users ORDER BY login_time DESC LIMIT 10?

[Back to original message]