How would we auto delete an entry after a specified amount of time from mysql. I was just wondering as no one has touched on this subject yet.
I don't think MySQL is that smart... you may need some type of scheduling tool to run a bit of SQL to do this.
May be you need TEMPORARY table? All entries in such table will be deleted with table with connection closing.