Implement the effect of playing a voice prompt when new information is available

Recently do a set of procedures, customer requirements when there is new information to play a voice to prompt, according to the situation, summed up the following ideas

Recently do a set of procedures, customer requirements when there is new information to play a voice to prompt, according to the situation, summed up the following ideas:

1, the information table to create a new field, and 0, 1 of the method to determine the status of information.

2, a new page, timed refresh, and query the table has a field value of 0 records.

3. When the administrator clicks to view the information, the field value is changed to 1.

The most critical of these is the 2nd step, which gives the required code below

Periodically refreshes the specified page. Like a new page called a.asp

So that's <script>settimeout ("location.href=" a.asp ' ", 10000) </script>

Database connection.
<%set rs = Conn.execute ("SELECT * from [table name] where field name = 0")
If not rs.eof then%>
<bgsound src= "Audio path" loop=false>

<%end if
Rs.close:set rs = nothing%>