Not sure if this is really a database question or a programming question... Basically, though, I'm going to be using a MySQL table for tracking user sessions. I know this is a very common technique, and it's simple enough to add the row when someone logs in, including an expiry time. But what's the best way to have rows automatically deleted when the session expires? Is that something that can be done on the database level, or do I just need to build a "trigger" into whatever script is using the database?
Thanks for any advice or suggestions.
Fractured Atlas :: Liberate the Artist
Services: Healthcare, Fiscal Sponsorship, Marketing, Education, The Emerging Artists Fund
Thanks for any advice or suggestions.
Fractured Atlas :: Liberate the Artist
Services: Healthcare, Fiscal Sponsorship, Marketing, Education, The Emerging Artists Fund