Hi Jason, thank you for your help!!
I had to make ONE modification to your new SQL query code, I had to change the 'h' to uppercase 'H' as the time in my database is stored in 24hr format.
This is the working SQL:
SELECT * FROM tasks WHERE tasks.dueDateTime = DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i')
I only figured that out when you changed the 'y' to 'Y' so I gave it ago and it worked.
Do you have any idea on how I would update the column "alertShown" to the value "1" for any record retrieved by the recordset query?
I want the query to function as follows:
SELECT * FROM tasks WHERE tasks.dueDateTime = DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i') AND tasks.alertShown <> "1"
I want to do this so I dont have the same alert generated 6x in one minute as my jQuery runs the recordset every 10 seconds. The default value for "alertShown" is "0".
Thank you very much for your help so far.