Populate Recordset only if current DATE and TIME matches

Thanks Jason and Brian for your input.

I think I would be best formatting the date to UK format within the recordset?

I have this currently:


SELECT * FROM tasks
WHERE session(userId) = tasks.assignedUserId
AND task.alertShown <> 1
AND tasks.TaskDateTime = DATE_FORMAT(NOW(), '%Y-%m-%d %h:%m');


Because I have a div tag on every page that calls the recordset every 10 seconds I need
to somehow set a value of "1" in the tasks table column "alertShown" so the user doesnt
see 10x popup messages with the same task listed within the minute.

The recordset will only contain data if the alertShown is not equal to the value "1"
and hence no popup message will be duplicated.

How would this be done?

Thanks very much for your help so far.