query help

[Anon]

I am developing a web base driven site with a backend to a database, MySQL. When a manager makes a new entry in the database, one minute late a javascraipt pop-up message displays on the affected area(s) workstation, but I cannot stop the message from displaying every 60 seconds. There are five areas: north, south, east, west, and a central area in the control room. What I am having trouble with is writing a query statement that will select an entry from from a table based on the current date and if the current time is greater than a new entry time + 1 minute.

$query="SELECT north, south, east, west, central, time_entered, date_entered FROM area_traffic WHERE (TIME_FORMAT(CURTIME(), '%H %i) > TIME_FORMAT(time_entered, '%H %i+1')) AND (CURDATE()=date_entered);

I have tried different time formats and nothing seems to work.

[[deleted]]

Using TIME_FORMAT in a query is bad. It works, but it will give you very bad performance if the number of records begins to grow.

Use the date calculation functions to find a date that is 60 seconds or 1 minute later than another:
http://www.mysql.com/doc/D/a/Date_and_time_functions.html

look for date_add etc.