MySQL.. Deleting by ID number

Anon

Hi, I have made a simple but effective news script using MySQL.. It works perfect, but now I just found that I need to make it delete old news, so the page doesn't get too big.. I would try this out, but I figured just asking would be much simpler 🙂

anyways, in my news table, every news post has an ID number, I know the number, If I wanted to delete all entries with IDs less than leat's say oh, 100.. Can I use:

mysql_query("DELETE FROM staffreq WHERE ID < 100");

would this work?

Thanks!

aspbyte

Why dont you add an ENUM field in the table...

Lets say if the article is active then value of the enum field is 'Y' ANd if inactive lets say enum field is 'n' When you need to clean the table say delete from tname where n_flag = 'n''

Pradeep Dsouza

Aspbyte Creations.com
Naharonline.com

[deleted]

That would work, but it's probably not what you want.

Instead, give every news item a date field. Whenever a new item is inserted, give it the current date (or use datetime so you can also add the time)

Then on your presentation page you can use a simple query to print only those items that are less than one day old, or less than a week, or less than a month...

Then you can also make an 'older news' button and let people search for items by date.

BTW: enum types are evil, don't use them.

A forum, a FAQ, what else do you need?