Posted by Richard Lynch on 04/20/05 07:16

On Tue, April 19, 2005 5:57 am, Ryan A said:
> 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....

One possibility not yet discussed...

I *think* MySQL has an 'array' data type.

You could then have an array of size 10 on each record.

Then, if MySQL has some kind of array_push and array_slice, you'd be able
to do:

update users set profile_viewers = array_slice(array_push($this_visitor,
profile_viewers), 1, 10) where user_id = $this_profile_id

Hopefully, you can even do something like:

select * from users as viewers, users as this_one
where this_one.user_id = $this_profile_id
and in_array(viewers.user_id, this_one.profile_viewers)

I have NO IDEA if MySQL actually has all this functionality, but if it
does, it may be more clear and/or efficient than a 10-to-1 table...

--
Like Music?
http://l-i-e.com/artists.htm

[Back to original message]