I\'ve got a small message board on my site which gets alot of messages.
I limit the number of rows of data returned by a SQL query using the limit function, so I select only the most recent 25 sorted by an auto incrementing message id. (larger the id the newer the message)
I also have a date posted column.
I want to have a button on my admin page that will allow me to delete all of the messages which are over say 30 days old but I am unsure as to the best way to structure this query.
Does anyone have any pointers as to the best way to proceed with this?
Many Thanks,
Paul Gabbott