New message script

NZ_Kiwis

I have a SQL database which has rows (each row is a msg to a user from userid and to_userid are in there. Plus there is a status

1 - New - Not Notified
2 - New - Notified
3 - Read
4 - Replied
5 - Deleted

I want a javascript which will run every 30 seconds and if there is a new row which has my userid ie: 3433 as the to_userid and it also has a stutus of "1" it brings up a pop on my screen. When I click okay it changes the DB status to "2"

Can someone help me with the basics ie: how to get a code to run every 30 seconds ect ect I can maybe try do most other parts but I've never used javascript before..

thanks for any help in advance :-)

theelectricwiz

Hello,

There are two basic ways you could do it.

One way to do it would be to use a hidden frame to call a php file that refreshs itself every 30 seconds. If the php detects a new email, the php could write javascript to move the iframe into position and create the popup.

Another would be to use a javascript xml request to again use a php to check for new messages. Javascript could then check what was sent in the xml request and act accordingly.

Hope this helps.

void_function

function refresh_me() {
  // Contact server using xmlHTTPRequest (without page reload) and ask for data
  myTimer= setTimeout (refresh_me, 30000);
}

// This in page onLoad function:
var myTimer= setTimeout (refresh_me, 30000);