Delete row when session expires

[Anon]

Hello. I was wondering if anyone knew how to delete rows from a mySQL table when a session expires (my session will expire when the user closes the window). If the script is terminated, how do I delete the rows other than manually.

The table contains a session id field that will identify the rows that need to be deleted. For example, there may be three rows in the table with the same session id that need to be deleted when the user leaves the site.

Thanks so much. I really appreciate it.

[finger]

dont believe that this is possible. i'd
suggest you handle the problem bye writing
a program, that get started several times
a day and deletes all entries older than ..
lets say 2 hours.

hope that helps
finger

[keegan]

This would be nice ... it would be one more feature to catch up with ASP's session model in terms of convenience. Maybe it's being developed for PHP5.

In the mean time, like Finger said, set up a cron job which periodically checks for expired sessions, and then you can do whatever you want with them.

-Keegan