Roost3r
10-20-2004, 05:25 PM
Hi,
I have a site that uses sessions and cookies, when a user visits my site i store their ip in my database to see whose currently viewing the site.... currently im also storing the time they visited a certain page (updating the tuple with the current time everytime they visit another page).... then to see whose online i query this table and check which ip's are there within a 3 minute span.... what i was wondering... is there a way for me to delete the tuple once the visitor or member leaves the site... a delete query that will occur when the session is destroyed? or is there a better way to doing this other than having a sql update on every webpage
(i searched the forum and didnt find a solution)
TIA
I have a site that uses sessions and cookies, when a user visits my site i store their ip in my database to see whose currently viewing the site.... currently im also storing the time they visited a certain page (updating the tuple with the current time everytime they visit another page).... then to see whose online i query this table and check which ip's are there within a 3 minute span.... what i was wondering... is there a way for me to delete the tuple once the visitor or member leaves the site... a delete query that will occur when the session is destroyed? or is there a better way to doing this other than having a sql update on every webpage
(i searched the forum and didnt find a solution)
TIA