MySQL problem: Show on update

Question

Hello! I wanted to know if its possible to display the contents of a mysql table on a page as soon as its contents are changed/updated

Thanks!

Answer 1

There are 2 conceptual methods for getting data from your server and updating your page accordingly: PUSH and PULL

The PULL method is one in which your page polls the server at a predefined interval to retrieve updated data and update the view accordingly. A search here or on Google for "server polling" or "ajax polling" will likely give you all the info you need to implement this approach.

The PUSH method is one in which the server pushes data down to the client (your page) when it is updated. The Ajax Push Engine (APE) is a framework for doing data PUSH operations over the web, I'd recommend checking it out if you want more info on this approach.

If you're looking for a more specific answer to your question, you'll need to post more relevant information about your problem, i.e.: server platform, programming language, etc...