Update record set every time database is updated
Posted on 2011-09-29
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?