Auto Refresh MySQL Content

[PromInc]

Here is my situation. I need my php page to refresh when data in the MySQL database is either modified or a new record is added to it.

What options do I have to get this to work?

Currently I am using a <META> tag to refresh the page on a timed interval. I don't like this solution because the data in the database could change anywhere from 30 seconds to 5 minutes. The biggest thing I can't stand though is that whenever it refreshes it will move the page back up to the top, so a user would have to scroll down the page again to view the content they were viewing.

Also, I AM NOT a fan of frames, so finding a way to accomplish this with out frames would make me much happier!

Thank you for your help in advance.

[Piranha]

The server can't contact to the browser to saying "Hello there, I have been updated so I am giving you a new page". The browser have to contact the server.

You probably want to use AJAX for this. I don't know much about it, but when you have read up on it someone else will answer your questions.