Deleting from SQL Database

[MagickCrafter]

How do I make it so it deletes anything in the database at a max of like 1000 fields? So my table doesn't become to large?

Thanks!!

[JDM71488]

if your table has a field to showing the "age" of a row, like a date, timestamp, or an auto-incrementing id field, you could have your php count the number of rows and if it is 1000 then delete the earliest row(s) with a limit of the difference of (count-1000).