<clip> >> 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.... </clip> ######## 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? ######## I am not checking for the last people logged in, I want to see the last people who have viewed the profile... each profile will have its own last "10 people visited" 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
