alfieshooter

Hi Am having problems with a query which I know should be really simple. I have a database called Fanfeed: username, fanof, type I want to be able to count how many unique entries each member has: Rita, Sue, R Rita, Sue, R Bob, Rita, R Sue, Bob, R Sue, Rita, R Bob, Sue, R Rita, Sue, R Sue, Bob, R Would output: Sue 2 Rita 2 Bob 1 (Even though Sue has 4 entries, she only has 2 unique entries from Bob and Rita etc.) I’m sure it should be easy...PLEASE HELP! Alfie.

I have a problem I'm sure should be easy to solve. Basically, I have a chat window which pops up when clicked from a parent window. When a user does this I want their status to change to 'online', so I make an entry in a database. When the user closes the chat window I want their status to change to 'offline', so I need to make a deletion from the database. I have it working using a combination of PHP and javascript, but I not happy with it. What I want to be able to do is set a session variable from the chat window, which will expire when it is closed down. However, what I don't know how to get around is, if the user keeps the chat window open, but closes the main parent window (which I would have used to refresh and check if the session was still active), then how do I know when the user closes the chat window, as the parent has been closed so I have nothing to check if the session is still active. Is it possible? Please help. Thanks