Jump to content


Photo

Deleting sql entries older than a certain date


  • Please log in to reply
1 reply to this topic

#1 Wanchope

Wanchope
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 01 July 2003 - 11:13 PM

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

#2 jhale1966

jhale1966
  • Members
  • PipPip
  • Member
  • 19 posts

Posted 01 July 2003 - 11:25 PM

Check the source for something like phpbb2. It\'ll have ALL that sorta info in it. :)




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users