Is it possible to make records expire from mysql. I want to have a table of show events, and as the date for the event goes the event disappears from the database. If this is not possible, how could you filter records from a database to only show dates that have not passed.
<?php mysql_query ("SELECT * FROM events WHERE [your conditions] AND date > 'yyyy-mm-dd'"); ?>
you also may add index for date field to speed-up selecting, when your table grow.
Would i need to set the date column to the date data type or can it be anything?
you need. i guess sorting will not work right if datatype differ.
