Write to a file a certain # of times

[Anon]

Hey I'm writing a news script and I want to write headlines every time I post some news, but I only want to display the 5 latest headlines. I'm guessing I would have to write to the headline file a certain number of times then after that overwrite the old information. How would I do that? Thanks!

[cybernacho]

The easiest way would probably need to use a mysql table to keep track of your updates. If you need any help setting that up I could help, if not all you would need to do to limit it to 5 posts is this:

mysql_query("SELECT * FROM updates ORDER BY id DESC LIMIT 5");

When you do this make sure "id" is set to auto-increment.

[Anon]

i would like help on setting up a mysql database 😛 please 🙂 preferably if i could set it up on my comp 🙂 i run iis right now for my server..