Hello, what I need to know is how to show a count of how many users are signed on with a custom sql script, here is what i got that shows total users but not total online
SELECT Buddies.*, Users.*, Pics.*, aspnet_Membership.*, (SELECT COUNT(*) AS Count FROM Buddies WHERE (Users.ParentUserID = Buddies.BuddyFromUserID)) AS Count FROM Buddies INNER JOIN Users ON Users.ParentUserID = Buddies.BuddyFromUserID LEFT OUTER JOIN Pics ON Pics.PicID = Users.DefaultPicID INNER JOIN aspnet_Membership ON Users.ParentUserID = aspnet_Membership.UserId WHERE (BuddyToUserID = '" & UserID & "') AND (BuddyStatus = 'Good')
Again this gives a total count but i need a total count of who is online with this setting, any help would be great and try to keep it in sql statement if possible as i have not yet learned how to use stored procedures.
...
Go to the complete details ...