Hello, I'm building a site that allows users to post comments like facebook. After say, 10 rows ( or 10 INSERT INTO's )I want the 1st row to be deleted as to control space in the data base. Any key words or links would help.
Jump to Post
There probably isn't a reason to actually delete records.
On the query you use to pull the comments you should add an ORDER BY clause that sorts them by the date they were added to the database (assuming you have a column for this) and then add a LIMIT …
All 3 Replies
Be a part of the DaniWeb community
We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.