PHP MySQL, pop up box when a new row is inserted in mysql database?

[Lukeidiot]

Hey guys, and thanks for reading,

 

I am trying to devise a way to make a pop-up box show whenever a new row is inserted into my MySQL database.

 

Any ideas or suggestions, maybe even an example or helpful information pointing to the right thing will be extremely delightful.

 

Thanks!

[Jessica]

What code have you written? Are you using any JS libraries? You know it's AJAX cause you posted here, where are you stuck?

[xyph]

You need to run an AJAX call that grabs the id of the 'newest row' from the database. Run this every 5 seconds or so, and store the result in a JS variable. If the value that you fetch is different than the value you've previously stored, you know an update has happened.

[Lukeidiot]

You need to run an AJAX call that grabs the id of the 'newest row' from the database. Run this every 5 seconds or so, and store the result in a JS variable. If the value that you fetch is different than the value you've previously stored, you know an update has happened.

 

Hmm I've been trying some things but none have seemed to work out. Perhaps a small example code?