asked on

Update record set every time database is updated

Hi all,

Is it possible to have a a recordset driven from PHP & MySQL update automatically without a page refresh when new data is entered into the database?

So the list may be ordered by any field ASC or DESC and displayed on a page, and when new data is entered it will insert the new data into the displayed list in the correct order.

I'm thinking AJAX, JQuery, obviously PHP and MySQL, but not quite sure where to start?
Want to keep it low server/page/memory intensive.

Anyone tried to achieve this before?

Thanks

ASKER CERTIFIED SOLUTION

Hugh McCurdy

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Ray Paseur

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Hugh McCurdy

Ray, thanks for the good post. As usual, I learn more just by hanging around.

dev, my comment on load was that you can drag down the server if you keep querying for changes every 100ms. Or if there are a "million" requests each "second." (Although a "million" requests has to be solved some other way, with more hardware.)

Good luck with your project. If you get stuck, people are here to help.

dev09

ASKER

Thanks guys, i've not quite put this into a working model but you've given me the right path to follow down!